Consultor Eletrônico



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   25/06/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.