Performing Transactions (ODBC)
SQL Server and the SQL Server Native Client ODBC driver support the ODBC API transaction management functions. Microsoft offers full support for local transactions on an individual server. The SQL Server Native Client ODBC driver uses these features to support the ODBC API functions that manage transactions.
Through the use of the Microsoft Distributed Transaction Coordinator (MS DTC), the SQL Server Native Client ODBC driver can participate in distributed transactions spanning multiple servers.