Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 70 / 536

Introduction to connections
50
3 If 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.