Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - Programming » Three-Tier Computing and Distributed Transactions » Three-tier computing architecture

How application servers use DTC Next Page

Distributed transaction architecture


The following diagram illustrates the architecture of distributed transactions. In this case, the resource manager proxy is either ODBC or OLE DB.

Architecture of distributed transactions: Client system with application server, top, connects to two database server systems, below, through resource manager proxies.

In this case, a single resource dispenser is used. The Application Server asks DTC to prepare a transaction. DTC and the resource dispenser enlist each connection in the transaction. Each resource manager must be in contact with both DTC and the database, so as to perform the work and to notify DTC of its transaction status when required.

A DTC service must be running on each computer to operate distributed transactions. You can control DTC services from the Services icon in the Windows Control Panel; the DTC service is named MSDTC.

For more information, see your DTC or EAServer documentation.