Kbase P124252: DefaultIsolationLevel registry key value for Data Source is incorrectly set.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
08/04/2011 |
|
Status: Unverified
SYMPTOM(s):
DefaultIsolationLevel registry key value for Data Source is incorrectly set.
DefaultIsolationLevel registry key value is SQL_TXN_REPEATABLE_READ if Default Isolation Level is not chosen.
Able to type any value in Default Isolation Level drop down list in Data Source Setup.
DefaultIsolationLevel registry key value is set to what is typed in Default Isolation Level drop down list in Data Source Setup.
DefaultIsolationLevel registry key value is set to Default Isolation Level drop down list text, not value.
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Windows NT 32 Intel/Windows 2000
CAUSE:
Bug # OE00152066
FIX:
In the Windows regeditor, navigate to HKEY_LOCAL_MACHINE > SOFTWARE > ODBC > ODBC.INI > [DSN name] and modify the DefaultIsolationLevel registry key value for the Data Source to one of these Default Isolation Levels:
Uncommitted Read:
SQL_TXN_UNCOMMITTED_READ
Committed Read:
SQL_TXN_COMMITTED_READ
Repeatable Read:
SQL_TXN_REPEATABLE_READ
Serializable:
SQL_TXN_SERIALIZABLE