Classic ASP connection string for SQL 2005???

Here is what I'm using, but I can't get it to work. This is in a conn.asp file.

Set Session("objConn") = Server.CreateObject("ADODB.Connection")
Session("objConn").Open Session("strDBConnect")
strDBConnect = "Provider=SQLOLEDB;Data Source=tcp:sql2k512.discountasp.net;database=***;uid=***;pwd=***;"

Here is my old Access connection string.

Set conn = Server.CreateObject("ADODB.Connection")
conn.open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=E:\web\***\htdocs\_database\***.mdb "

Thanks, Brian

 

Doing this with a Session object can make it tricky but your actual connection string is correct.
Try moving the strDBConnect up above the Open statement.

 

Do you know of an easier way to do it? I am open to suggestions. It doesn't have to be a sesson object. I'm using this because I was able to piece it together from bits of code. Ideally I would like something as simple as my old string.


I will try your suggestion, though.


Thanks, Brian

 

Thanks for the suggestion, but it didn't work. Is there another way to write the connection string, similar to my old one?


Thanks, Brian

 

A good source of connection strings is:
http://www.connectionstrings.com/

You can also find a lot of resources by using my Google Coop:
http://www.google.com/coop/cse?cx=009244845836111659857%3Albvxsjj8mho

 

My developer was able to find the answer. Thanks, Brian