IBM Information Server Informix Wire Protocol driver error "Transaction not available" from ODBC Connector Stage - United States  TECHNOTE (TROUBLESHOOTING)

PROBLEM(ABSTRACT)
 When using the ODBC Connector Stage to access data in an Informix database, receive the following error:

Message: ODBC_Connector_0: ODBC function "SQLPrepare" reported: SQLSTATE = HY000: Native Error Code = -95: Msg = [IBM(DataDirect OEM)][ODBC Informix Wire Protocol driver][Informix]Unexpected Network Error.
ODBC function "SQLPrepare" reported: SQLSTATE = HY000: Native Error Code = -256: Msg = [IBM(DataDirect OEM)][ODBC Informix Wire Protocol driver][Informix]Transaction not available. (CC_OdbcDBStatement::dbsPrepare, file CC_OdbcDBStatement.cpp, line 347)


RESOLVING THE PROBLEM
To resolve the above error, set the Transaction handling>Isolation Level from none to Auto-Commit.
Column Analysis on Informix database using odbc connector fails with error SQLSTATE = HY000: Native Error Code = -256 Column Analysis on Informix database using odbc connector fails with error SQLSTATE = HY000: Native Error Code = -256
To resolve the above error, set the Transaction handling>Isolation Level from none to Auto-Commit.