Could not start a transaction for OLE DB provider '%ls'.
Microsoft® SQL Server™ also returns this error message if the provider is a SQL Server-specific provider:
Only one transaction can be active on this session.
The OLE DB provider returned error 7392 because only one transaction can be active for this session. This error indicates that a data modification statement is being attempted against an OLE DB provider when the connection is in an explicit or implicit transaction, and the OLE DB provider does not support nested transactions. SQL Server requires this support so that, on certain error conditions, it can terminate the effects of the data modification statement while continuing with the transaction.
SET XACT_ABORT is ON. This causes SQL Server to terminate the surrounding transaction when there is an error while processing the data modification statement. If SET XACT_ABORT is ON, SQL Server does not require nested transaction support from the OLE DB provider.
| Distributed Queries | SET XACT_ABORT |
| Errors 7000 - 7999 |