ECDA Option for ODBC

ECDA version 15.0, the Option for DB2 UDB and the Option for Microsoft SQL Server have been merged into the ECDA Option for ODBC. In addition, the Option for Informix is no longer available.

ECDA Option for ODBC provides basic connectivity to DB2 UDB, Microsoft SQL Server, and ODBC-accessible databases.

NoteThe ODBC driver for ECDA Option for ODBC (the back-end driver connecting to the target) is not provided by Sybase; you must obtain, install, and configure it.

ECDA Option for ODBC provides access to non-Sybase data sources, using the ODBC back-end (server-side) driver that you obtain for your target database, such as IBM or Microsoft SQL. Following the vendor’s instructions, install the ODBC driver on the same server as ECDA Option for ODBC and then configure ECDA Option for ODBC to use the ODBC driver for access to your database.

NoteBe sure to verify that your ODBC driver is compatible with Sybase driver manager software or that it contains a driver manager.

Because ODBC drivers have varying degrees of functionality, it is important that when working with non-Sybase-provided, third-party ODBC drivers, you carefully integrate and test them to be sure they meet your needs.