MDAC 2.5 SDK - ADO


 

IsolationLevelEnum

    Applies To

Specifies the level of transaction isolation for a Connection object.

Constant Value Description
adXactUnspecified -1 Indicates that the provider is using a different isolation level than specified, but that the level cannot be determined.
adXactChaos 16 Indicates that pending changes from more highly isolated transactions cannot be overwritten.
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 have been committed.
adXactReadCommitted 4096 Same as adXactCursorStability.
adXactRepeatableRead 65536 Indicates that from one transaction you cannot see changes made in other transactions, but that requerying can retrieve new Recordset objects.
adXactIsolated 1048576 Indicates that transactions are conducted in isolation of other transactions.
adXactSerializable 1048576 Same as adXactIsolated.

ADO/WFC Equivalent

Package: com.ms.wfc.data

Constant
AdoEnums.IsolationLevel.UNSPECIFIED
AdoEnums.IsolationLevel.CHAOS
AdoEnums.IsolationLevel.BROWSE
AdoEnums.IsolationLevel.READUNCOMMITTED
AdoEnums.IsolationLevel.CURSORSTABILITY
AdoEnums.IsolationLevel.READCOMMITTED
AdoEnums.IsolationLevel.REPEATABLEREAD
AdoEnums.IsolationLevel.ISOLATED
AdoEnums.IsolationLevel.SERIALIZABLE