Microsoft ActiveX Data ObjectsMicrosoft ActiveX Data Objects*
*Contents  *Index  *Topic Contents

IsolationLevel Property - ADO

Indicates the level of isolation for a Connection object.

Applies To

Connection

Settings and Return Values

Sets or returns one of the following IsolationLevelEnum values:
Constant Description
adXactUnspecified Indicates that the provider is using a different IsolationLevel than specified, but that the level cannot be determined.
adXactChaos Indicates that you cannot overwrite pending changes from more highly isolated transactions.
adXactBrowse Indicates that from one transaction you can view uncommitted changes in other transactions.
adXactReadUncommitted Same as adXactBrowse.
adXactCursorStability Default. Indicates that from one transaction you can view changes in other transactions only after they've been committed.
adXactReadCommitted Same as adXactCursorStability.
adXactRepeatableRead Indicates that from one transaction you cannot see changes made in other transactions, but that requerying can bring new recordsets.
adXactIsolated Indicates that transactions are conducted in isolation of other transactions.
adXactSerializable 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.

Remote Data Service Usage When used on a client-side Connection object, the IsolationLevel property can only be set to adXactUnspecified.

Examples

IsolationLevel and Mode Properties Example (VB)


Up Top of Page
© 1997 Microsoft Corporation. All rights reserved. Terms of Use.