Kbase 21407: Error 7671 when attempting to update a record from a ODBC or JDBC client
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/25/2008 |
|
Status: Verified
SYMPTOM(s):
Error attempting to update a record
Connecting with either the SQL-92 ODBC Driver or SQL-92 JDBC Driver
Statement not allowed in read only isolation level (7671)
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
CAUSE:
The Default Isolation Level is set to Read Uncommitted. This type of isolation level does not allow updates to the database; a higher Isolation Level is required for database updates.
FIX:
Set the Default Isolation level to a level higher than Read Uncommitted. Use one of the following values:
Read Committed
Repeatable Read
Serializable
On UNIX
Change the DefaultIsolationLevel parameter in the ODBC.INI file to one of the following settings.
On Windows
Change the Default Isolation Level using the Advanced Tab of the ODBC driver. From SQL Explorer, go to the View menu > Options.