Programming Components Deployed in Sybase EAServer, MTS or COM+

Create components that participate in distributed transactions in Sybase EAServer, MTS, or COM+.

  1. Call SQLDriverConnect once for each Adaptive Server connection you want to establish.
  2. Call SQLExecDirect once for each insert or update SQL statement.
  3. Deploy your component to MTS, and configure the transaction attributes as needed.

The transaction coordinator creates a distributed transaction as needed, and the component that uses the Adaptive Server ODBC Driver automatically enlists in the global transaction. Then, the transaction coordinator commits or rolls back the distributed transaction.