Web Development

Ask something
Discussion Locked

Visual Interdev 6 question

0 helpful
5 replies

by srini43085

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I am trying to develop a DHTML page to access a SQL Server 2000 database using client-side recordsets.
I went through the following steps ...
1. Created a new web project in VI6
2. Added data connection to the project
3. Added data command object to the project
4. Added a new HTML page to the project and opened it
5. The DTC scripting platform was set to client-side(DHTML)
6. Dragged the data command object to the HTML page to create a recordset DTC.
7. Added a text box DTC to the page with source set to above recordset and the field set to one of the fields in the table.
8. saved and previewed in browser but I dont see any data.(Seems like the recordset doesnt get opened)

What am I missing?

BTW I created an ASP page with DTC scripting set to server using the same data connection & command objects and that works fine. Its just when I switch to client-side DTC platform that I dont get any data.

P.S. I also tried using the ADC control and a MSFlexGrid for client side recordset retrieval but that too doesnt return any rows.

Thanks
- Srini

5 replies

by madestroitsolutions

Thats a tough one man, hard to tell without looking at it, but The only thing I can think of is that the provider doesnt support client side recordsets, so Why dont you simply use ADO?

Good luck and I hope that helps.

by madestroitsolutions

Thats a tough one man, hard to tell without looking at it, but The only thing I can think of is that the provider doesnt support client side recordsets, so Why dont you simply use ADO?

Good luck and I hope that helps.

This discussion is closed to new replies.