Sybase IQ supports ODBC and JDBC connectivity. Sybase IQ 15.1 uses Adaptive Server Anywhere to store catalog information.
Sybase IQ versions prior to 12.0 used Adaptive Server Enterprise 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.
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 accessing data in the IQ Store through any supported interface.
