Connecting from adaptive server iq utilities – Sybase 12.4.2 User Manual

Page 82

Advertising
background image

Simple connection examples

62

pwd=

password

Note

Do not use these parameters if more than one local server is running, or

you may connect to the wrong server.

Default database

If more than one server is running, you need to specify which one you wish to
connect to. If only one database has been started on that server, you do not need
to specify the database name. The following connection string connects to a
named server, using the default database:

eng=

server_name

uid=

user_id

pwd=

password

No defaults

The following connection string connects to a named server, using a named
database:

eng=

server_name

dbn=

db_name

uid=

user_id

pwd=

password

For more information about default behavior, see “How Adaptive Server IQ
makes connections”.

Connecting from Adaptive Server IQ utilities

Adaptive Server IQ database utilities that communicate with the server (rather
than acting directly on database files) do so using Embedded SQL. They follow
the procedure outlined in “How Adaptive Server IQ makes connections” when
connecting to a database.

How database utilities
obtain connection
parameter values

Many of the administration utilities obtain the connection parameter values by:

1

Using values specified on the command line (if there are any). For
example, the following command starts the collation utility on the sample
database on the default server, using the user ID

DBA

and the password

SQL

and the asiqdemo.col collation file:

dbcollat -c "uid=DBA;pwd=SQL;dbn=asiqdemo"

c:\temp\asiqdemo.col

Advertising