Error 0x 80004005 when you access to an Acess DB from ASP with IIS 6

Posted by Cereal Thursday, December 13, 2007 6:00:00 AM Categories: _Tous les articles Windows 2003
Rate this Content 0 Votes

SYMPTOMS 1
"Disk or Network Error" or "Unspecified Error" Returned when Using JetWhen trying to connect to an Access .mdb file, an ODBC error is returned stating "Disk or Network Error". The Microsoft OLE DB Provider for the Microsoft Jet database engine may also return an "Unspecified error" (error code = 0x80004005) message.

The problem can occur only when the data source is opened under the Microsoft Internet Information Server (IIS) or a Microsoft Windows NT service but not under a logged-on user account.

 

CAUSE 1
Jet creates a temporary file when the engine is started. In doing so, it first checks the TMP environment variable and uses that path to define where the temporary file is created. If it doesn't see a TMP environment variable, it looks for the TEMP environment variable. If TEMP is not defined, it then uses the Windows folder (\WINDOWS or \WINNT).

If TMP/TEMP is defined but points to a nonexistent folder, the error occurs. WARNING : When you change the TMP and TEMP path use the real path to the destination directory not %xxxxxx%.Sample :C:\TEMP
Moreover, when opening the Access database through IIS or a Windows NT service, and when IIS or the service is running under the local system account, the TMP or TEMP system environment variable is used. When the Web services or Windows NT service are started using a user account, the TMP/TEMP user profile environment variables is used.

 

RESOLUTION 1
Define a TMP or TEMP environment variable and assign the variable to an existing folder. If you are accessing the Access database from IIS, be certain to check the system environment settings rather than environment variables of the logged-on user. Also ensure that the IUSER anonymous IIS account has access to the temporary folder. Add permission “Full Control” to :EveryoneIUSR_IWAM_

You must restart the computer after changing any environment variables.
Environment variables are set under Windows NT 4.0 by going to the Control Panel and clicking System and then selecting the Environment tab.

 

MORE INFORMATIONS 1
This article was previously published under Q251254 210457 ASP 0115 or Inetinfo Application Error Occurs on ASP File Running Database Query 164535 Random Errors When Performing IDC or ASP Queries to an Access Database  

 

APPLIES TO 1
Internet Information Service (IIS) 5, 6

 

SYMPTOMS 2
Error Message: 0x80004005: General Error Unable to Open Registry Key.When you access a page that connects to an Access database, you may receive the following error message in the browser: 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 0x614 Thread 0x6c0 DBC 0x21dd07c Jet'.
(FileName), (LineNumber)

 

CAUSE 2
The account that is being used to access the page does not have access to the “HKEY_LOCAL_MACHINE\SOFTWARE\ODBC” registry key.

 

RESOLUTION 2
Start Registry Editor (Regedt32.exe).
Select the following key in the registry:
”HKEY_LOCAL_MACHINE\SOFTWARE\ODBC”
On the Security menu, click Permissions.Add permission “Full Control” to :EveryoneIUSR_IWAM_
Type the required permissions for the account that is accessing the Web page.
Quit Registry Editor.

 

MORE INFORMATIONS 2
This article was previously published under Q295297
Simple-Tech.info
Comments are closed on this post.
Site Map | Printable View | © 2008 - 2012 Simple-Tech.info | Powered by mojoPortal | HTML 5 | CSS | Design by mitchinson