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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Programming » Three-tier computing and distributed transactions » Three-tier computing architecture


The vocabulary of distributed transactions

This section assumes some familiarity with distributed transactions. For information, see your transaction server documentation. This section describes some commonly used terms.

  • Resource managers are those services that manage the data involved in the transaction.

    The SQL Anywhere database server can act as a resource manager in a distributed transaction when accessed through ADO.NET, OLE DB, or ODBC. The SQL Anywhere .NET Data Provider, OLE DB provider, and ODBC driver act as resource manager proxies on the client computer. The SQL Anywhere .NET Data Provider supports distributed transactions using DbProviderFactory and TransactionScope.

  • Instead of communicating directly with the resource manager, application components can communicate with resource dispensers, which in turn manage connections or pools of connections to the resource managers.

    SQL Anywhere supports two resource dispensers: the ODBC driver manager and OLE DB.

  • When a transactional component requests a database connection (using a resource manager), the application server enlists each database connection that takes part in the transaction. DTC and the resource dispenser perform the enlistment process.

 Two-phase commit