Error with Connection Objectq

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

Re: Error with Connection Objectq

Bryan wrote:
> 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?
>
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

--
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"