SAP Knowledge Base Article - Preview

2184750 - Default isolation level set by ODBC DSN setting is overridden by client application


  • ODBC DSN setting has default isolation level of 0
  • An ODBC application explicitly modifies the isolation level by calling SQLSetConnectAttr and sets SQL_TXN_ISOLATION value to SQL_TXN_SERIALIZABLE, which is isolation level 3



  • Any supported versions of SAP SQL Anywhere
  • Any supported versions of Sybase SQL Anywhere
  • ODBC application


SAP SQL Anywhere all versions ; SQL Anywhere all versions


ODBC-enabled, app, uncommitted, committed, repeatable_read, repeatable, read, snapshot, statement, change, asa, anyhwere , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , BC-SYB-SQA-CLI , SQL Anywhere - Client libraries (odbc, jdbc ...) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.