making a dsn connection

[Irvin]

I am very new to dot net! In fact, this is my first go at it, and
would like to know how to change an adodb connection via dsn to dot
net? The database is in Access 2000.".

This is my original code:

set cn = server.CreateObject("ADODB.connection")
set rs = server.CreateObject("ADODB.recordset")

rs.Open "SELECT * FROM Products;", "dsn=my_db", 3, 2
...
...
rs.close
cn.close
set rs = nothing
set cs=nothing

Thanks for your help.

 

[Cor]

Hi Irvin,

Is there a reason you go to dotnet and keeps the recordset and not the
dataset.

(Not that it is impossible, but the ones who do this change after a while
and maybe you can do it direct)

Cor