Today, when I was doing ASP to save data to MSSQL, the following error message appeared:
Microsoft OLE DB Provider for ODBC Drivers Error '80040e21' A multi-step OLE DB operation has an error. Please check each OLE DB status value. No work was done.
After checking, the data type is incorrect, and the saved data length exceeds the field length set by the database.
The following are the information you are looking for online:
When writing data to the database, there are type mismatch, field size exceeding, lock mode errors, etc., or the record set is not closed in time.
For example, if a field configured has a length of 15, it is necessary to try to insert 16-bit characters in the SQL statement; or try to insert fields with incorrect full-width half-width mode;
Or the wrong record set locking method is used, sql, conn, x, y, according to some blog articles, modifying the method of opening record sets may solve this problem.
It turns out that the normal program I have been using suddenly reported
Microsoft OLE DB Provider for ODBC Drivers Error '80040e21'
The ODBC driver does not support the required properties.
There is no problem with fewer records inquiry, if there are more records, this error will be reported
Cleaning up windows\Temp folder, inetpub\temp folder, but it still doesn't work.
Search online
Microsoft OLEDB Provider for ODBCDrivers (0x80040E21)-->sql statement error (data type mismatch or table name (field name) error or table is in edit state, or table does not exist in a database opened by conn)
Finally, I found that just changing the application pool identity to LocalSystem is enough. It is obviously a matter of permissions. It is finally time to change the folders you can think of.
Friendly reminder: Changing the application pool logo to LocalSystem is very unsafe