Informix - Problem description
Problem IT10695 | Status: Closed |
THE ISOLATION LEVEL SET IN THE DSN DEFINITION IS NOT APPLIED IF A CALL TO SQLSETCONNECTATTR IS MADE BEFORE SQLCONNECT | |
product: | |
IBM CSDK / 5724C2381 / 410 - CSDK 4.10 | |
Problem description: | |
If you have an odbc program that executes the sequence of calls: SQLAllocHandle(SQL_HANDLE_DBC, henv, &hdbc); SQLSetConnectAttr (hdbc, SQL_ATTR_AUTOCOMMIT, (SQLPOINTER) 0, 0); //or some other attribute != SQL_ATTR_TXN_ISOLATION SQLConnect(hdbc, dsn, SQL_NTS, uid, SQL_NTS, pwd, SQL_NTS); and the DSN definition explicitly sets an isolation level different than the default, for example ISOLATIONLEVEL=5 ( last committed) the isolation setting will be ignored and the connection will have the default isolation level. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * Application using Informix ODBC driver. Isolation level set * * in the DSN definition is not applied if a call to * * SQLSetConnectAttr happens before SQLConnect. * **************************************************************** * PROBLEM DESCRIPTION: * * Application using Informix ODBC driver. Isolation level set * * in the DSN definition is not applied if a call to * * SQLSetConnectAttr happens before SQLConnect. * **************************************************************** * RECOMMENDATION: * * The problem has been fixed with CSDK 4.10.xC6. Please * * upgrade the product to this version or higher. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.08.2015 30.12.2015 30.12.2015 |
Problem solved at the following versions (IBM BugInfos) | |
4.10.xC6 | |
Problem solved according to the fixlist(s) of the following version(s) | |
4.10.xC5 | |
4.10.xC6 |