How to establish connection with DB(SQL Server 2000)

[arshak]

Hi.

Please give me a short example, with using connection to DB(SQL Server 2000).

I used a lot of tutorials but unfortunately me strive was not good. I tried ADO, ODBC, but I think that I do something wrong

Please show me a right way.

Thank you for any suggestion.
Best regards.

 

[SrinuReddy]

use ADO to connect to DB.

set con = server.createobject("ADODB.CONNECTION&quot

con.open "connection string"

that's it !

srinu...