Three solutions for longer data that cannot be taken out of an ASP page

Solutions for longer text data that cannot be taken out of an ASP page

When you take long text data from a recordset in an ASP page, you receive the following error behavior:

Microsoft OLE DB Provider for ODBC Drivers error ' 80040e21 '

Errors occurred

There are three ways to do this:

(i) open a recordset using the Rs.Open sql,conn,1,3 method

(ii) Put the column in the first column out, such as comment store a longer text content, take the recordset content, first come to a comment=rs ("comment") to take out the trick of the things to put in the memory variable, and then operate the other fields. Because the general long text content does not appear in the first display, it is generally taken out to be placed in a memory variable.

(iii) The database is connected to OLE DB mode. This error does not occur when you connect to the database in this way (at least I haven't encountered it). In my system, the error appears immediately after the current OLE DB connection is changed to ODBC connection mode.

This error is suspected to be caused by an ASP's mechanism for fetching data from the recordset returned by ODBC. A third approach is recommended to avoid this error.