title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | |||
---|---|---|---|---|---|---|---|---|---|---|---|
Transactions (Native Client OLE DB provider) |
Transactions in SQL Server Native Client |
markingmyname |
maghan |
03/14/2017 |
sql |
native-client |
reference |
|
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
The [!INCLUDEssNoVersion] Native Client OLE DB provider 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, the [!INCLUDEssNoVersion] Native Client OLE DB provider can join transactions initiated and maintained by MS DTC.
By default, the [!INCLUDEssNoVersion] Native Client OLE DB provider uses an autocommit transaction mode, where each discrete action on a consumer session comprises a complete transaction against an instance of [!INCLUDEssNoVersion]. The [!INCLUDEssNoVersion] Native Client OLE DB provider autocommit mode is local, and autocommit transactions never span more than a single session.
The [!INCLUDEssNoVersion] Native Client OLE DB provider exposes the ITransactionLocal interface, allowing the consumer to use explicitly and implicitly start transactions on a single connection to an instance of [!INCLUDEssNoVersion]. The [!INCLUDEssNoVersion] Native Client OLE DB provider does not support nested local transactions.