Export (0) Print
Expand All
1 out of 1 rated this helpful - Rate this topic

Transactions

SQL Server 2000

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 MS DTC.

By default, SQLOLEDB uses an autocommit transaction mode, where each discrete action on a consumer session comprises a complete transaction against an instance of Microsoft® SQL Server™ 2000. SQLOLEDB autocommit mode is local and 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 connection to an instance of SQL Server 2000. SQLOLEDB does not support nested local transactions.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.