Sybase IQ Version 12.6 supports ODBC and JDBC applications. It uses Adaptive Server Anywhere (ASA) 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 IQ version 12.x, but third-party and customer-written Open Client™ DB-Library and Client-Library applications are unlikely to perform as expected.
When developing Open Client applications to run with Sybase IQ 12.x, avoid using catalog tables or system stored procedures supported by Adaptive Server Enterprise but not Sybase IQ. See Appendix A, “Compatibility with Other Sybase Databases,” in the Sybase IQ Reference Manual.
ASA 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 ASA, but only if these applications use the system tables, views and procedures that are found in ASA. System procedures, catalog tables, and views available in ASA are listed in the Sybase IQ Reference Manual. There are no restrictions accessing data in the IQ Store through any supported interface.
