Several popular PC applications have been tested in-house with Sybase IQ using the ODBC interface. Other front-end clients may work with Sybase IQ, but have not been tested.
For information on third-party vendor applications that are certified with Sybase IQ, refer to the section “Sybase certifications on the Web” in the Sybase IQ Release Bulletin.
The Sybase IQ ODBC Driver is shipped with Sybase IQ as part of the Network Client CD and installed automatically.
See “Creating ODBC data sources” for information on how to set up an ODBC Data Source if you need to access a database or data file over a network using ODBC.
The following note applies to third-party PC client applications certified with Sybase IQ:
With BrioQuery, each query requires you to connect to the database. Be sure to close the query after processing to ensure that the connection to Sybase IQ is closed. If you leave multiple queries open, you could consume more connections than you realize, eventually preventing other users from connecting to Sybase IQ (since the number of configured connections would be exceeded).
See the Sybase IQ Release Bulletin for problems that may affect using PC client applications with Sybase IQ.