Kbase P131074: SQL: User using an ODBC client is unable to read records locked by other 4GL/ABL or SQL clients.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/29/2010 |
|
Status: Verified
SYMPTOM(s):
SQL: User using an ODBC client is unable to read records locked by other 4GL/ABL or SQL clients.
Executing an SQL query against a table whose records are locked by other users return an empty result set.
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
CAUSE:
The DSN transaction isolation level is set to REPEATABLE read.
FIX:
Set the DSN transaction isolation level to READ UNCOMMITTED