Groups | Blog | Home
all groups > inetserver asp db > march 2007 >

inetserver asp db : Error with Connection Objectq


Bryan
3/22/2007 12:33:04 PM
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

Bob Barrows [MVP]
3/22/2007 9:35:22 PM
[quoted text, click to view]
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"

AddThis Social Bookmark Button