Sybase 12.4.2 User Manual

CHAPTER 2    Running Adaptive Server IQ

To establish a connection, the client application calls functions in one of the 
supported interfaces. Adaptive Server IQ supports the following interfaces:

•

ODBC — ODBC connections are discussed in this chapter.

•

Embedded SQL — Embedded SQL connections are discussed in this 
chapter.

•

Sybase Open Client — Open Client connections are not discussed in this 
chapter. For information on connecting to IQ from Open Client 
applications, see Chapter 14, “Adaptive Server IQ as a Data Server”

•

JDBC — JDBC connections are not discussed in this chapter. For 
information on connecting via JDBC, see Chapter 4, “Managing 
Databases with Sybase Central” in Introduction to Adaptive Server IQ. To 
create JDBC data sources, see the chapter entitled “Data Access Using 
JDBC” in the Adaptive Server Anywhere User’s Guide.

JDBC provides the link between the execution of Java objects and 

database operations. For a description of Java support in Adaptive Server IQ, 
see “Enabling Java in the database” on page 113.

The interface uses connection information included in the call from the client 
application, perhaps together with information held on disk in a file data 
source, to locate and connect to a server running the required database. The 
following figure is a simplified representation of the pieces involved.

Learning about 
connections

Some examples to get started quickly

“Simple connection examples”