dsn-less connection problem

Justine · March 8th, 2004, 12:04 PM

Hi, I was wondering if you could help me with this.

I am trying to set up a dsn-less connection from my asp page. I'm using the following code and I get this error. Am I making any strange mistakes? Is there something else I should be doing? I appreciate any ideas you may have.

Data source name not found and no default driver specified.

myDSN="Driver={SQL server};Server=prod;Database=web_code;Uid=web_code ;Pwd=webpwd"

Set conn = Server.CreateObject("ADODB.Connection")
conn.open myDSN,"",""

joefawcett · March 8th, 2004, 12:22 PM

Go to www.connectionstrings.com, look at the strings for SQL Server under OleDb Connection (.net), the one you are using is an odbc string, inefficient and less flexible.

Code:

sConnString = "Provider=sqloledb;Data Source=prod;Initial Catalog=web_code;User Id=web_code;Password=webpwd;" 
Set oConn = CreateObject("ADODB.Connection")        
oConn.ConnectionString = sConnString
oConn.open;

--

Joe

Justine · March 8th, 2004, 12:43 PM

Thank you for your help! I added the providor argument and placed the code into my asp file instead of in the include. I'm not sure why the include makes a difference. Is there any reason why you wouldn't be able to put this information into an include file? Thanks again!

Justine

joefawcett · March 8th, 2004, 01:45 PM

None at all, providing you are referencing the file correctly.

--

Joe