%META:TOPICPARENT{name="ConfigureUDAFeatures"}%
= Setting Transaction Isolation Levels for connections to Progress/<nop>OpenEdge =

%TOC%

== Enterprise Edition Multi-Tier Drivers ==

# Log in to the Broker host.
# Use a text editor to open the active Rulebook (default is {{{/<...OpenLink Installation...>/bin/oplrqb.ini}}}).
# Locate the relevant {{{Environment}}} section, e.g., {{{[Environment PROGRESS110SQL]}}}, {{{[Environment PROGRESS100SQL]}}}, or {{{[Environment PROGRESS91SQL]}}}.
# Add the following keyword to the existing list of parameters:
{{{
DEFAULT_TXN_ISOLATION 
}}}
# Set your desired transaction isolation level. The options are:
{{{
READ_UNCOMMITTED
READ_COMMITTED
REPEATABLE_READ
SERIALIZABLE
}}}
For instance:
{{{
DEFAULT_TXN_ISOLATION = READ_UNCOMMITTED
}}}
# Save your changes and exit the file.
# Restart or reinitialize your Request Broker service to activate the change.


== Lite Edition Single-Tier Drivers ==

# Log in to the machine hosting the driver.
# Launch the ODBC Administrator.
# Locate & highlight your Data Source Name.
# Click **Configure.**
# Locate the **Default Transaction Isolation** menu.
# Select your desired isolation level.
# Save the changes to your DSN.