Error with Connection Objectq

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bryan - 22 Mar 2007 20:33 GMT

Hey guys, I need a bit of quick help. I have a website that I have been working that worked fine while I was working on it on my computer, but I just tried to publish it now to the server and keep getting an error. Here is the error that I am getting:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xd0 Thread 0x5b8 DBC 0xe63b024 Jet'.

/SalesDBConnect.ASP, line 20

Now, here is the lines of code in the file that it is refering to:

    Dim objConn
    Set objConn = Server.CreateObject("ADODB.Connection")
    objConn.ConnectionString="DRIVER={Microsoft Access Driver (*.mdb)};" & _
                            "dbq=" & Server.MapPath("/Pro Sales Reports.mdb")
    objConn.Open

Can anyone tell me waht I might be doing wrong and how I can fix this?

Thanks,

Bryan

Reply to this Message

Bob Barrows [MVP] - 23 Mar 2007 02:35 GMT

> Hey guys, I need a bit of quick help. I have a website that I have
> been working that worked fine while I was working on it on my
[quoted text clipped - 18 lines]
>
> Can anyone tell me waht I might be doing wrong and how I can fix this?

This error is a consequence of using the ODBC driver instead of the native
Jet OLE DB provider. See:
http://www.aspfaq.com/show.asp?id=2126

Signature

Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Reply to this Message

Webmaster Forum / ASP / Database Access / March 2007

Error with Connection Objectq