Error: "...ODBC ResultSet...could not complete the requested operation" when running LSXODBC agent
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:
More support for:
IBM Enterprise Integrator for Domino
Software version: 7.0, 8.0, 8.5
Operating system(s): AIX, IBM i, Linux, Solaris, Windows
Reference #: 1515245
Modified date: 12 October 2013