How connections are established

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

NoteJDBC provides the link between the execution of Java objects and database operations. For a description of Java support in Sybase IQ, see “Enabling Java in the database”.

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.

Figure 3-1: Interface library connects applications to servers

Shown is the interface library’s relationship among client application, disk in a file data source and the database

Learning about connections

If you want ...

Consider reading ...

An overview of connecting from Sybase Central or Interactive SQL (including a description of the drivers involved)

“Connecting from Sybase Central or Interactive SQL”

Some examples to get started quickly

“Simple connection examples”

A conceptual overview

“How connection parameters work”

To learn what connection parameters are available

Chapter 4, “Connection and Communication Parameters”

To create data sources

“Working with ODBC data sources”

To see an in-depth description of how connections are established

“Working with ODBC data sources”

To add users and grant them permissions

“How Sybase IQ makes connections”

To diagnose network-specific connection issues

“Troubleshooting network communications” in the Sybase IQ Troubleshooting and Error Messages Guide

To learn about character set issues affecting connections

“Connection strings and character sets”