SQLOLEDB implements local transaction support. The consumer can use distributed or coordinated transactions by using Microsoft Distributed Transaction Coordinator (MS DTC). For consumers requiring transaction control that spans multiple sessions, SQLOLEDB can join transactions initiated and maintained by the Microsoft Distributed Transaction Coordinator.
By default, SQLOLEDB uses an autocommit transaction mode, where each discreet action on a consumer session comprises a complete transaction against a SQL Server. SQLOLEDB autocommit mode is local. Autocommit transactions never span more than a single session.
SQLOLEDB exposes the ITransactionLocal interface, allowing the consumer to use explicitly and implicitly started transactions on a single SQL Server connection. SQLOLEDB supports nested local transactions.