How Sybase IQ Establishes Connections

To establish a connection, the client application calls functions in one of the supported interfaces.

Sybase IQ supports the following interfaces:

ODBC — ODBC connections are discussed in this chapter.
OLE DB — OLE DB connections are discussed in this chapter.
Embedded SQL — Embedded SQL connections are discussed in this chapter.
— This chapter does not describe Open Client connections. For information on connecting to IQ from Open Client applications, see System Administration Guide: Volume 2 > Sybase IQ as a Data Server.
JDBC — This chapter describes JDBC connections. For more information on connecting via JDBC, see Introduction to Sybase IQ > Managing Databases. To create JDBC data sources, see SQL Anywhere Server - Programming > JDBC support.

Note: This reference points to SQL Anywhere documentation.

Note: JDBC provides the link between the execution of Java objects and database operations.

The interface uses connection information included in the call from the client application, possibly together with connection information stored on disk in a file data source, to locate and connect to a server running the required database.