How connections are established – Sybase 12.4.2 User Manual

Page 71

Advertising
background image

CHAPTER 2 Running Adaptive Server IQ

51

How connections are established

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.

Note

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

If you want ...

Consider reading ...

Some examples to get started quickly

“Simple connection examples”

Advertising