Data Source name not found

[smsinger3]

Hello all. I am having a problem where I can't logon to a sql server 7 database in asp. I have no idea why. Here is the error I am getting:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


I get the error with any of these connection strings:
1) DSN=dsnname;SRVR=servername;UID=logonid;PWD=password
2) ODBC;DSN=dsnname;SRVR=servername_dev;UID=logonid;PWD=password
3) DSN=dsname;DATABASE=databasename;Provider=MSDASQL.1;UID=logonid;PWD=password
--------------------

Here is the code that I execute:

Set l_adoConn = CreateObject("ADODB.Connection&quot
l_adoConn.ConnectionTimeout = Application("ConnTimeout&quot
l_adoConn.open conn_str <...the connection strings from above ...>

Do you know why I keep getting this error? I'm sure it's something stupid...

thanks for your help!

Steve S
sms@hmbnet.com

 

[Geee]

I am presuming you have a System DSN set up on your server pointing to the SQL database. Try the following connection string...

&quot;myDSN&quot;, &quot;MyUserName&quot;, &quot;MyPassword&quot;

Always seems to work for me.

G -GTM Solutions, Home of USITE-
-=

http://www.gtmsolutions.com=-

 

[dianal]

Hello,
Look at faq333-178 also.
D.