Sybase Adaptive Server IQ 12.4.2, Administration And Performance Manual

Page: 73 / 536

CHAPTER 2 Running Adaptive Server IQ
53
You must enter a connection string on a single line, with the parameter settings
separated by semicolons.
Connection parameters are passed as connection strings
Connection parameters are passed to the interface library as a connection
string. This string consists of a set of parameters, separated by semicolons.
In general, the connection string built up by an application and passed to the
interface library does not correspond directly to the way a user enters the
information. Instead, a user may fill in a dialog box, or the application may read
connection information from an initialization file.
Certain Adaptive Server IQ utilities accept a connection string as the
-c
command-line option and pass the connection string on to the interface library
without change. For example, the following is a typical Collation utility
(
dbcollat
) command line for Windows NT systems. It should be entered all on
one line.
dbcollat -c "uid=DBA;pwd=SQL;dbn=asiqdemo"
c:\temp\asiqdemo.col
Note
DBISQL processes the connection string internally. It does not simply
pass on the connection parameters to the interface library. Do not use
Interactive SQL to test command strings from a command prompt.
Simple connection examples
Although the connection model for Adaptive Server IQ is configurable, and
can become complex, in many cases connecting to a database is very simple.
This section describes some simple cases of applications connecting to an
Adaptive Server IQ database. When you are getting started, this section may be
all you need, for example, if you are running the
asiqdemo
sample database on
a local server and are not connected to a network. However, in most IQ
environments, in order to ensure that you can connect and disconnect properly,
a very complete set of connection parameters is essential.