IsolationLevel Property

Indicates the level of isolation for a Connection object.

Settings and Return Values

Sets or returns one of the following IsolationLevelEnum values:

Constant	Value	Description
adXactUnspecified	-1	If the provider is using a different IsolationLevel than specified but which one cannot be determined, the property returns this value.
adXactChaos	16	Indicates that you cannot overwrite pending changes from more highly isolated transactions.
adXactBrowse	256	Indicates that from one transaction you can view uncommitted changes in other transactions.
adXactReadUncommitted	256	Same as adXactBrowse.
adXactCursorStability	4096	Indicates that from one transaction you can view changes in other transactions only after they've been committed. (Default.)
adXactReadCommitted	4096	Same as adXactCursorStability.
adXactRepeatableRead	65536	Indicates that from one transaction you cannot see changes made in other transactions, but that requerying can bring new recordsets.
adXactIsolated	1048576	Indicates that transactions are conducted in isolation of other transactions.
adXactSerializable	1048576	Same as adXactIsolated.

Remarks

Use the IsolationLevel property to set the isolation level of a Connection object. The IsolationLevel property is read/write. The setting does not take effect until the next time you call the BeginTrans method. If the level of isolation you request is unavailable, the provider may return the next greater level of isolation.

Applies To

Connection