Automatic Transaction Enlistment

It is not always apparent to the consumer when a provider is not automatically enlisted in transactions. Specifically, in the following cases enlistment does not occur:

  • The provider does not support aggregation. To use OLE DB services, providers must support aggregation of all objects.

  • The OLEDB_SERVICES registry entry does not exist. For information about how to add an OLEDB_SERVICES registry entry, see Setting Provider Service Defaults.

  • The provider has not enabled automatic transaction enlistment by assigning an appropriate value to the OLEDB_SERVICES registry entry. For more information, see Overriding Provider Service Defaults.

  • The provider does not support the ITransactionJoin interface.