Function Sequence Error

Symptoms

When there is data extraction from Informix database there might be an error specified below. [Informix ODBC Driver] Function Sequence Error.

Cause

An asynchronously executing function is called for the hstmt and is still executing when this function is called, or an attempt was made to use an hstmt out of sequence. For example, you are trying to execute an EXECUTE statement before the PREPARE statement is finished.

Solution

To solve this problem you need to change the default value of Cursor Behavior from Close value to Preserve in the Environment tab in IBM Informix ODBC Driver Setup window.

If you have any other questions, please contact us: support@ispirer.com