SAP Knowledge Base Article - Preview

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

Symptom

  • 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


Read more...

Environment

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

Product

SAP SQL Anywhere all versions ; SQL Anywhere all versions

Keywords

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 for Me (Login required).

Search for additional results

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