Problems Connecting to ODBC Database.

[ctau]

I am having problems connecting to an ODBC database. I am using the following code

Set MyConnection = Server.CreateObject("ADODB.Connection&quot
MyConnection.Open SQL, "dsn = wacs"


I get the following error when I run this. Line 31 is the DSN line.

___________________________________________________________
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

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

/intranet/WACS_Customer.asp, line 31

____________________________________________________________

Thanks for the Help

Ctau

 

[giahan]

Have you created the ODBC DSN for SQL yet? The error seems like you haven't assigned the DSN. Also, the command should be:
Set MyConnection = Server.CreateObject("ADODB.Connection&quot
MyConnection.Open "DSN= = yourDSN; DataBase = yourDB"

Hope it helps


GH

 

[mrichards]

You might consider not using DSN at all. The connections are faster. go to

http://www.4guysfromrolla.com/webtech/042599-1.shtml

You can see how to do it.

Mark