Setting Transaction Isolation Levels for connections to Progress/OpenEdge

Enterprise Edition Multi-Tier Drivers

1. Log in to the Broker host.
   
2. Use a text editor to open the active Rulebook (default is /<...OpenLink Installation...>/bin/oplrqb.ini).
   
3. Locate the relevant Environment section, e.g., [Environment PROGRESS110SQL], [Environment PROGRESS100SQL], or [Environment PROGRESS91SQL].
   
4. Add the following keyword to the existing list of parameters:
   
   

   
   DEFAULT_TXN_ISOLATION 
   

   
   
5. Set your desired transaction isolation level. The options are:
   
   

   
   READ_UNCOMMITTED
   READ_COMMITTED
   REPEATABLE_READ
   SERIALIZABLE
   

   
   For instance:
   
   

   
   DEFAULT_TXN_ISOLATION = READ_UNCOMMITTED
   

   
   
6. Save your changes and exit the file.
   
7. Restart or reinitialize your Request Broker service to activate the change.

Lite Edition Single-Tier Drivers

1. Log in to the machine hosting the driver.
   
2. Launch the ODBC Administrator.
   
3. Locate & highlight your Data Source Name.
   
4. Click Configure.
   
5. Locate the Default Transaction Isolation menu.
   
6. Select your desired isolation level.
   
7. Save the changes to your DSN.