IIS and ODBC Database Access
Having problems accessing my Access Database. I get this error. Its not the Asp because I had it running on a Personal Webserver.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x3dc Thread 0x578 DBC 0x101c344 Jet'.
/maylong.asp, line 70
Any Suggestions?
Peter J. Boettcher posted this at 13:22 — 7th August 2002.
They have: 812 posts
Joined: Feb 2000
Is your path to the database correct? Make sure you're using a physical path and not a virtual one. Make sure the database and the folder it is in is accessible to your IUSR_machinename account.
PJ | Are we there yet?
pjboettcher.com
modemgoons posted this at 00:42 — 14th August 2002.
They have: 5 posts
Joined: Aug 2001
The DSN is correct and the file is local, so it should work. I think it has something to do with permissions but I dont know exactly how to set them.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.
/adsCanada/addNotify.asp, line 70
Is the error. Any help is appreciated.
Peter J. Boettcher posted this at 13:09 — 14th August 2002.
They have: 812 posts
Joined: Feb 2000
It sounds like permissions. Just go into Windows Explorer, navigate to the folder that contains the database, check the folders properties (right-click) and check the security tab. If you don't see the IUSR_machinename (replace machinename with the name of your computer) account there then you should add it with full access. If it is there make sure it has full (read/write/modify) access.
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.