2053313 - How to change the isolation level for an OLE DB connection in Crystal Reports?

SAP Knowledge Base Article - Public

2053313 - How to change the isolation level for an OLE DB connection in Crystal Reports?

Symptom

  • How to change the isolation level?
  • Is it possible to change the isolation level for an OLE DB connection in Crystal Reports?

Environment

  • SAP Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Resolution

  • It is not possible to change the isolation level for an OLE DB connection because Crystal Reports has no option to turn on/off isolation level when using OLE DB.
          
  • If you need to change the Isolation Level, then use an ODBC connection. 
    For details on how to change the isolation level for an ODBC connection, see the SAP Knowledge Base Article 1216415

Keywords

CR, Isolation Level, IsolationLevel, Read Committed, Read Uncommitted, Dirty Read, OLE DB, OLEDB , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016