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

Technote (troubleshooting)


Problem

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."
    or
    "Error in ODBC ResultSet: LS:DO- ODBC could not complete the requested operation."

Cause

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:

    result.Close(DB-Close)
    con.disconnect


Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Enterprise Integrator for Domino
ODBC

Software version:

7.0, 8.0, 8.5

Operating system(s):

AIX, IBM i, Linux, Solaris, Windows, i5/OS

Reference #:

1515245

Modified date:

2011-09-13

Translate my page

Machine Translation

Content navigation