Performing Transactions (ODBC)

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.