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 notes apply 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).
In order to create attribute tables for PowerBuilder properly, you need to run the iqpb.sql script located in the Server directory on the PowerBuilder product CD against Sybase IQ v.12.0.x using the provided Sybase IQ ODBC driver. Earlier versions of PowerBuilder (6.5 and below) do not include the script. In this case, obtain the script from the Sybase FTP Web site. Contact your PowerBuilder support representative if you need additional information or a newer version of PowerBuilder.
See the Sybase IQ Release Bulletin for problems that may affect using PC client applications with Sybase IQ.
The AUTOSTOP parameter is required in file data sources and odbc.ini files. It should always be set to NO.