OLE DB Provider for ODBC Drivers error '80004005'

Routhg · #1 (**permalink**) June 10th, 2003, 06:01 PM

I get the following error when trying to post to my database:
-----------------------------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/Connect.inc, line 8
-----------------------------------------
Connect.inc, lines 6-8 are:
'Create and open the database object
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open Application("ConnectString")

Where do I specify what Application("ConnectString") is? I'm afraid that was in global.asa and I have hosed that up! :( With no backup, of course.
The DNS = SOF, no password required

Can you recommend some code (and whether it goes in global.asa or not) to fix this?

Thanks!
Gary

pgtips · #2 (**permalink**) June 11th, 2003, 03:14 AM

If you have a DSN named SOF already set-up then the connection string is simply "DSN=SOF". There's nothing wrong with putting it in global.asa, like this

Code:

Sub Application_OnStart
    Application("ConnectString") = "DSN=SOF"
End Sub

Routhg · #3 (**permalink**) June 11th, 2003, 07:02 AM

pgtips,
That was exactly what I was missing! Thanks a million:)

Need to download code?

Navigation