An application program initiates a transaction by:
For example, the application program uses the ODBC SQLSetConnectOption to propagate the MS DTC transaction object to resource managers that support ODBC. All subsequent work done on the ODBC connection is performed as part of the transaction. When the resource manager becomes aware of the MS DTC transaction, it enlists in the transaction with its local MS DTC transaction manager. This permits the resource manager to participate in the two-phase commit protocol and to receive transaction commit or abort notifications from MS DTC.
For example, the application might insert, delete, or update records in a relational database, or it might invoke a database stored procedure that modifies the relational database.
Application programs that initiate MS DTC transactions must reside on a system on which either the Complete MS DTC Service or the MS DTC Client Utilities has been installed. The resource manager must reside on a system on which the Complete MS DTC Service has been installed. For information on installation and configuration of MS DTC, refer to "Setting Up an MS DTC System" in the MS DTC Administrator's Guide and Programmer’s Reference.