Error running LS:DO agent on DB400 database: "Error 720: ls:do-odbc could not complete the requested operation"

Technote (FAQ)


Question

When you pull data from a DB400 database using an LS:DO agent, the following error occurs after a certain amount of records are processed:


    "Error 720: ls:do-odbc could not complete the requested operation."

Cause

When you use an SQL statement to reference a string, you have to list the string in quotation marks. Some of the records in the DB400 data contained fields with names that were already in quotation marks. When the agent reached these records, it did not know how to process the extra quotations marks and would fail.

Answer

In this particular case, the developer altered the agent code to allow for the quotes in the DB400 database. After doing so, the agent was able to process the entire DB400 database without error.


Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Lotus End of Support Products
Lotus Domino

Software version:

6.0, 6.5, 7.0

Operating system(s):

i5/OS

Reference #:

1279884

Modified date:

2009-11-21

Translate my page

Machine Translation

Content navigation