In Lotus Enterprise Integrator (LEI), when running a LSXODBC agent over HTTP, you receive one of the following errors intermittently:
"Error 720- LS:DO- ODBC could not complete the requested operation. Error in ODBC Connection."
"Error in ODBC ResultSet: LS:DO- ODBC could not complete the requested operation."
This situation occurs when the LSXODBC agent contains a disconnect to the datasource which is not preceded by a "close" of the ResultSet class.
Resolving the problem
The Disconnect method is part of the ODBCConnection Class and the Close Method is part of the ODBCResutSet Class. A "Disconnect" severs you from the datasource while a "Close" terminates the ResultSet.
To correct this issue, you should always close the ResultSet before disconnecting the datasource. Replace the end text, "con.disconnect", as follows: