Cannot connect to Database

[johndayo]

Can anyone help me. I'm having trouble connecting to my database (SQL Server), and receive the error shown below. I'm connecting to the db using a connection string which is set in the global.asa file. All the parameters for the connection are correct. Any possible solutions are welcomed even the most blindingly obvious as this is driving me mad.


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


Cheers
Dayo

 

[ukwebsite]

Can you post your connection string so that we can see it? Matthew Wilde
matthew@ukwebsite.com

 

[johndayo]

Application("ConnectionString&quot = "Provider=SQLOLEDB.1;Password=password;" & _
"Persist Security Info=True;User ID=UserID;" & _
"Initial Catalog=db_name;Data Source=server_name"

 

[Jonax]

... and how do you open the connection?

conn.open Application("ConnectionString")

?? This is not a bug - it's an undocumented feature...
;-)

 

[johndayo]

Yep

or MyConn.Open strConn

 

[Eduu]

It seems to me like you just copied the connection string from somewhere and pasted it in there - I could be wrong though!
Is password(small letters) the password you use to connect to your database?
Is UserID your user name?
Replace db_name with the name of the table you want to connect to.
Rplace server_name with the name of the machine your database is situated on.
Something like this

Provider=SQLOLEDB.1;Password=MyBusiness;Persist Security Info=False;User ID=sa;Initial Catalog=CDResource;Data Source=TEST-2002

Hope you understand.