IT10695: THE ISOLATION LEVEL SET IN THE DSN DEFINITION IS NOT APPLIED IF A CALL TO SQLSETCONNECTATTR IS MADE BEFORE SQLCONNECT

APAR status

• Closed as fixed if next.

Error 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.
  

Local fix

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.               *
  ****************************************************************
  

Problem conclusion

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

• R410 PSY

     UP