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