Sybase 12.4.2 manual Introduction to connections, Stopping Sybase Central

Introduction to connections

3If Adaptive Server IQ (ASIQ) is listed, select Register. If not, select Load.

Use the Browse button to find and select the file ASIQPlugin.jar. Click OK.

Stopping Sybase Central

To stop Sybase Central, select File → Exit.

Introduction to connections

The remainder of this chapter describes how client applications connect to databases. It contains information about connecting to databases from ODBC applications and application development systems, as well as from Embedded SQL applications.

Any client application that uses a database must establish a connection to that database before any work can be done. The connection forms a channel through which all activity from the client application takes place. For example, your user ID determines permissions to carry out actions on the database—and the database server has your user ID because it is part of the request to establish a connection.

This sounds simple, but some client tools may not clearly indicate connection status, and a failed command is your first indication that the connection does not exist. For a novice user, a quick way to confirm the connection is by a simple select db_name().

The syntax is:

select db_name()

to display the current database, or

select db_name([ database_id ])

to display any database you specify.

50