Kbase P114041: .Net program retrieves data using ReadCommitted even though ReadUncommitted is specified
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
07/03/2006 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
SYMPTOM(s):
.Net program retrieves data using ReadCommitted even though ReadUncommitted is specified
Problem cannot be reproduced using tool like WinSQL
CAUSE:
The connection string in .Net was specifying the DSN and the DRIVER, HOST, PORT and DefaultIsolationLevel options in the connection string. When specifying the DSN option the other options should not be specified (other than UID and PWD for username and password).
CAUSE:
Modify the connection string to use only the DSN, UID and PWD options for connecting to the database via ODBC