Performing Transactions (ODBC)

SQL Server 2000

In ODBC, transactions cannot span connections. ODBC applications can use the standard ODBC transaction management functions to work with transactions on individual connections. ODBC applications can also use the Microsoft Distributed Transaction Coordinator (MS DTC) to include multiple Microsoft® SQL Server™ connections in a single transaction, even when the connections are to separate servers.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)