How Do I look at the Microsoft SQL 2000 table data in VB 6.0 Applicati

[Hpatel]

Hi,
i used to use ADODC to look at the data from ACCESS database table. Now that table has been moved to SQL SERVER 2000. I dont know how to LOOK at the data from SQL SERVER. Any HELP would be appreciated.
Thank you,

HPATEL

 

[sach]

Hi H,
Have you considered using ADODB recordsets. They can be used to query data from tables in SQL Server2000. you can find data about how to use it on the net.

sachin

 

[IonelBurtan]

You should use:
- ADODB.Connection - for database connection which can be either through ODBC or through OLE DB(faster).
- ADODB.Recordset - for reading/writing operation on the opened connection to SQL Server 2000

if you want to execute some Stored Procedure you should use the execute method from the ADODB.Connection object.

Hope of being of some help, s-) Blessed is he who in the name of justice and good will, shepards the week through the valley of darknees...