Microsoft OLE DB Provider for ODBC Drivers Error 80040e21

Error Message Microsoft JET Database Engine Error '80004005' Unspecified Error

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

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft ][ODBC Microsoft Access Driver] Common error cannot open the registry keyword 'Temporary (volatile) Jet DSN for process 0x1f0 Thread 0xd44 DBC 0x203e024 Jet'.

Provider error '80004005' Unspecified error

Microsoft JET Database Engine error The '80004005' operation must use an updatable query.

The cause of the failure This type of error usually occurs in the NTFS format of the file system. It is caused by insufficient IIS anonymous account (IUSR_computer name) for related files and folders. First, store the database folder for IIS anonymous account does not write, modify permissions, the error is that the database can not be updated, write Second, the system temporary folder directory for IIS anonymous account is not written, modify permissions, the error is expressed as access Any file on the server that uses the Microsoft JET Database Engine to link to the Access class database is an error. This error does not occur under normal circumstances. When using some system garbage cleanup optimization tools, or some other factors, this directory permission may change. So please use such tools with caution.

Solution 1. Check whether the folder that stores the Microsoft Access database file has write access to the IIS anonymous account. If not, please assign the write permission, especially when the error message is (Microsoft JET Database). The Engine error '80004005' operation must use an updateable query.).

Second, the JET engine will create a temporary file in the %windir%/temp/directory when linking the database, and the IIS anonymous account has insufficient permission to operate the %windir%/temp/directory. Add an IIS anonymous account ( IUSR_computer name) can read and write permissions to %windir%/temp/.

Other unspecified errors can be attempted to re-register the ASP script to interpret the link library file. Run the following commands in order: 1.regsvr32 jscript.dll 2.regsvr32 vbscript.dll 3.iisreset Reference Case 2: Microsoft OLE DB Provider for ODBC Drivers Error '80040e21' The multi-step OLE DB operation generated an error. If possible, check each OLE DB status value. No work was done. This error occurs when the server attempts to process a page that contains an "update record" or "insert record" server behavior. The database was unable to process the update or insert attempt that the server behavior attempted to perform. The possible causes and solutions are as follows: The server behavior is trying to update the autonumber field of the database table or try to insert a record in the autonumber field. Since the autonumber field is automatically populated by the database system, any attempt to populate these fields with values ​​from outside will fail. The server behavior is updating or inserting data that is the wrong type for the database field, such as inserting a date into a Boolean (yes/no) field, inserting a string into a numeric field, or inserting a malformed string into " Date/time" field. The above error occurred during the Oracle ODBC connection operation today. The things found on the Internet are saved here to see if it is useful. The format of an item is incorrect, especially the time format and number format. It must be filled in according to the format. The content of some items should not exceed the length of the field. Check what you have entered, and check the fields you added. The input is formatted.