Isolation Retention Property

ADO and SQL Server

ADO and SQL Server

Isolation Retention Property

The Isolation Retention property specifies the supported transaction isolation retention levels.

Applies To
Connection Object
Syntax

object.Properties("Isolation Retention")

Parts

object

Expression that evaluates to an object in the Applies To list.

Returns

A bitmask containing zero or more of these settings.

Constant Description
DBPROPVAL_TR_ABORT The transaction preserves its isolation context across a retaining abort.
DBPROPVAL_TR_ABORT_DC The transaction may either preserve or dispose of isolation context across a retaining abort.
DBPROPVAL_TR_ABORT_NO The transaction is explicitly not to preserve isolation across a retaining abort.
DBPROPVAL_TR_BOTH Isolation is preserved across both a retaining commit and a retaining abort.
DBPROPVAL_TR_COMMIT The transaction preserves its isolation context (that is, it preserves its locks, if that is how isolation is implemented) across a retaining commit.
DBPROPVAL_TR_COMMIT_DC The transaction may either preserve or dispose of isolation context across a retaining commit.
DBPROPVAL_TR_COMMIT_NO The transaction is explicitly not to preserve isolation across a retaining commit.
DBPROPVAL_TR_DONTCARE The transaction may preserve or dispose of isolation context across a retaining commit or abort. This is the default.
DBPROPVAL_TR_NONE Isolation is explicitly not to be retained across either a retaining commit or a retaining abort.
DBPROPVAL_TR_OPTIMISTIC Optimistic concurrency control is to be used. If DBPROPVAL_TR_OPTIMISTIC is specified, and then whatever isolation technology is in place (such as locking), it must be the case that other transactions' ability to make changes to the data and resources manipulated by this transaction is not in any way affected by the data read or updated by this transaction. That is, optimistic control is to be used for all data in the transaction.

Data Type

adInteger

Modifiable

Read-only

OLE DB Property

DBPROP_SUPPORTEDTXNISORETAIN