Using a DSN

Jasonmr2 · #1 (**permalink**) 01-28-04, 11:29

Currently I am using the following method to connect to my DB in ASP. I want to now use a DSN that has been created on my server called "MyWeb" how would my string look using this DSN?

cn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Final.mdb;Persist Security Info=False"

MrWizard · #2 (**permalink**) 01-28-04, 15:30

Quote:

Originally posted by Jasonmr2
Currently I am using the following method to connect to my DB in ASP. I want to now use a DSN that has been created on my server called "MyWeb" how would my string look using this DSN?

cn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\Final.mdb;Persist Security Info=False"

cn.open "DSN=MyWeb"

Tim

Bullschmidt · #3 (**permalink**) 02-03-04, 03:43

Or I believe even this would work:

cn.open "MyWeb"

Internet Services

Web Development

Digital Marketing

Consumer Tech