Solutions for longer text data cannot be retrieved in Asp pages

When retrieving long text data from recordset in Asp pages, the following error occurs:

are three solutions to occurred:

(1) Use rs.open sql,conn,1,3 to open the recordset.

(2) Place the column in the first column and retrieve it. For example, a comment contains long text content. When retrieving the contents of the recordset, first use comment=rs("comment") to retrieve this troublesome thing and place it in memory variables, and then manipulate other fields. Since generally long text content will not be displayed first, it is generally taken out and placed in memory variables.

(3) Change to oledb method to connect to the database. This error will not occur when connecting to the database in this way (at least I haven't encountered it before). In my system, after changing the current oledb connection method to odbc connection method, an error immediately appeared.

This error is suspected to be caused by a problem with Asp's mechanism for retrieving data from the recordset returned by odbc. A third method is recommended to avoid this error.

--------------From: VI8-----------------------------