Transactions (OLE DB)

In this section, simple transactions, nested transactions, distributed transactions, and transaction isolation are discussed.

A transaction enables a consumer to specify that a sequence of operations within a session must be performed as a single unit. Whether providers support transactions is provider-specific. If the provider supports transactions, a session object that supports ITransactionLocal can enter a simple (that is, non-nested) transaction.

A nested transaction occurs when a transaction is begun within the scope of another transaction. This inner transaction is represented by a transaction object. Providers that support nested transactions can choose to commit or abort a transaction at the outermost level or to commit or abort one of the inner transactions. ITransactionOutcomeEvents is implemented by the consumer to discover the outcome of transaction events.

The transaction object and transaction options object cotypes are defined as follows. For more information about cotypes, see Conceptual Programming Models in OLE DB.

CoType TTransaction {
   [mandatory]   interface IConnectionPointContainer;
   [mandatory]   interface ITransaction;
   [optional]    interface ISupportErrorInfo;
};

CoType TTransactionOptions {
   [mandatory]   interface ITransactionOptions;
   [optional]    interface ISupportErrorInfo;
};

Remarks

This topic is a part of:

• Microsoft OLE DB