MDAC 2.5 SDK - ODBC Programmer's Reference
Chapter 14: Transactions
Transactions in ODBC are completed at the connection level; that is, when an application completes a transaction, it commits or rolls back all work done through all statement handles on that connection.