Long TEXT data cannot be taken out in the ASP page
When the recording set is long when the recording collection is tetaged, the following error occurs:
Microsoft OLE DB Provider for ODBC Drivers Errors '80040E21'
Errors Occurre
There can be three solutions:
(1) Open record sets using RS.Open SQL, CONN, 1, and 3
(2) Put the column in the first column. For example, there is a longer TEXT content in Comment. When recording the contents of the sequence, first come first = rs ("comment") to put this quail egg thing first Go to the memory variable, then operate other fields. Since the general length of Text content is not in the first display, it is generally taken in the memory variable.
(3) Change to OLEDB to connect to the database. This way is connected to the database in this manner, there is no such error (I started to have I have encountered). In my system, after the current OLEDB connection is changed to the ODBC connection method, the error will appear immediately.
This error is suspected to be due to some problems with the mechanism of the recorded data returned by the ASP to ODBC. It is recommended to avoid this error.
