Error & #39; 80040e21 & #39; multiple-step OLEDB operation Error

Source: Internet
Author: User
The following error message is displayed when ASP is used to save data to MSSQL: MicrosoftOLEDBProviderforODBCDrivers error 80040e21 multiple-step OLEDB operation produces an error. Check the status value of each OLEDB. No work is completed. After checking that the data type is incorrect, the length of the stored data exceeds the length of the field set by the database. The following is the information found on the Internet:

The following error message is displayed when ASP is used to save data to MSSQL: MicrosoftOLEDBProviderforODBCDrivers error '80040e21' multi-step OLEDB operation produces an error. Check the status value of each OLEDB. No work is completed. After checking that the data type is incorrect, the length of the stored data exceeds the length of the field set by the database. The following is the information found on the Internet:

The following error message is prompted when ASP is used to save data to MSSQL:
Microsoft ole db Provider for ODBC Drivers error '80040e21' multi-step ole db operation produces error. Check the status value of each ole db. No work is completed.

After checking that the data type is incorrect, the length of the stored data exceeds the length of the field set by the database.

The following information is available on the Internet:

When writing data to the database, the Type mismatch, the field size exceeds, and the locking mode error occurs, or the record set is not closed in time.

For example, if the length of a specified field is 15, you must try to insert a 16-bit character in an SQL statement, or try to insert a field with incorrect full-width half-width mode;

You can also use the wrong record set locking method, such as rs. open SQL, conn, x, and y. According to some blog posts, modifying the method of opening the record set may solve this problem.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.