Kbase 21335: How To Change Isolation Level When Using Crystal Reports 8
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Verified
GOAL:
How to change the Isolation level when using Crystal Reports 8.
FACT(s) (Environment):
Progress 9.1x
Windows 32 Intel
Windows NT 32 Intel/Windows 2000
FIX:
Changing the Isolation Level setting in Windows ODBC Data Sources does not affect Crystal Report.
To change the Isolation level when using Crystal Reports 8, follow the following procedure:
1) Download the file Isolevel.zip from Seagate's website:
http://support.seagatesoftware.com
2) Install the the DLL P2sodbc.dll as mentioned in the Installation Notes.
A new Key called "IsolationLevel" is created in the registry under,
[HKEY_CURRENT_USER\Software\Seagate Software\Crystal Reports\DatabaseOptions\ODBC].
3) Add the appropriate Value for the IsolationLevel as follows :
1 is "uncommitted read"
2 is "committed read"
3 is "repeatable read"
4 is "serializable"