SAP Knowledge Base Article - Public

1183629 - How to apply isolation levels for ODBC

Symptom

How do you change isolation level for ODBC?

Resolution

To set a different isolation level for ODBC when using Crystal Reports XI, set the registry entry:

HKEY_CURRENT_USER(or HKEY_LOCAL_MACHINE)\SOFTWARE\Business Objects\Suite 11.0\Crystal Reports\Database\ODBC

If the registry entry is not available, create the key by performing the following steps:
  1. Close Crystal Reports XI if it is already running.
  2. Create a new text file with the following text:
    [HKEY_LOCAL_MACHINE\SOFTWARE\Crystal Decisions\11.0\Crystal Reports\Database\ODBC]
    "IsolationLevel"=dword:00000004
  3. Save the file as "isolationlevel.reg" on your desktop and close the file.
  4. Go to your desktop and double-click on the file isolationlevel.reg. A message will appear asking you to confirm whether you want to save modifications to your registry.
  5. Click Yes. Another message will appear saying that the registry has been modified successfully.
  6. Finally, open Crystal Reports XI and create a report using the ODBC connection.  

NOTE

You can change the IsolationLevel value to 1 (Read Uncommitted), 2(Read Committed), 4 (Readable Read) or 8 (Serializable) according to your isolation level requirement.

Keywords

different isolation levels forODBC , 1222010 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

SAP Crystal Reports XI ; SAP Crystal Reports XI R2