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.