IBM Support

Error: "...ODBC ResultSet...could not complete the requested operation" when running LSXODBC agent

Technote (troubleshooting)


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:


Document information

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

Translate this page: