ECDA Option for ODBC

ECDA Option for ODBC is Open Server-based software that supports Client-Library and Open Database Connectivity (ODBC) application programming interfaces (APIs).

A local area network (LAN)-based middleware server, ECDA Option for ODBC provides access to non-Sybase data and applications and basic connectivity to ODBC-accessible datasources.

ECDA Option for ODBC serves as a fundamental building block for highly scalable database middleware applications. In addition, you can use ECDA Option for ODBC with other Sybase products, such as Adaptive Server/Component Integration Services (CIS), Replication Server, and Replication Server Options.

Note: For access to additional databases, such as Microsoft SQL Server, DB2 UDB, and others, you must obtain and install the necessary ODBC driver separately, on the same server as ECDA Option for ODBC, and configure ECDA Option for ODBC to use that ODBC driver for access to the database.Carefully integrate and thoroughly test with non-Sybase provided, third-party ODBC drivers.

ECDA Option for ODBC is a symmetric multiprocessing (SMP) that uses an Open Server thread for each incoming client connection. It communicates with Adaptive Server using the server class direct_connect.

These rules define the relationship between an access service library and an access service:

A single access service library can support multiple access services.
Each access service has one configuration set and is always associated with a specific access service library.
All access services within a given access service library share the same configuration properties.
You can assign different configuration property values to different access services within an access service library.

When a client connects, the access service logs in to the target database, using the client user ID and password, plus the ODBC-configured datasource name (DSN).