Sybase IQ supports ODBC and JDBC applications. It uses Adaptive Server Anywhere as the server for storing catalog information.
Sybase IQ versions prior to 12.0 used Adaptive Server Enterprise as catalog server. ODBC applications used as client front-end tools with older versions of Sybase IQ will continue to run in Sybase IQ 12.7, but third-party and customer-written Open Client™ DB-Library and Client-Library applications are unlikely to perform as expected.
The only Open Client applications that run with Sybase IQ 12.x are user-written or isql applications that use only catalog tables or system stored procedures supported by both Adaptive Server Enterprise and Adaptive Server Anywhere (ASA).
Sybase IQ is compatible with clients (like Open Client-Library and DB-Library) that use TDS. Open Client version 11.1.1 supports TDS 5.x and applications would therefore work with Sybase IQ, but only if these applications use the system tables, views, and procedures that are found in Sybase IQ. System procedures, catalog tables, and views available in Sybase IQ are listed in the Sybase IQ Reference Manual. There are no restrictions to accessing data in the IQ Store through any supported interface.
