PDA

Click to See Complete Forum and Search --> : Help!


Skeen
Nov 1st, 2000, 03:28 AM
Can anyone tell me what this error means in english! I'm trying to connect my asp's to an oracle database and its all going belly up!

Microsoft OLE DB Provider for ODBC drivers error '80004005'

[Microsoft][ODBC driver manager]Data source name not found and no default driver specified.


The error message occurs on this bit of code:

Set cnAcqAcc = CreateObject ( "ADODB.Connection" )
cnAcqAcc.ConnectionString = "Provider=MSDASQL;DSN=CustServ;UID=CustServ_owner;PWD=CustServ_owner;"

cnAcqAcc.open

I think its my provider in my connection string, but can anyone tell me what I'm doing wrong

Cheers n beers

Skeen

Orpheus
Nov 1st, 2000, 05:27 AM
Have you created the DSN on your machine (through ODBC Manager) ?

Skeen
Nov 1st, 2000, 05:47 AM
I'm going through an IIS Server and I reckon thats where the problem is.