Sybase 12.4.2 manual Connecting to other databases from Dbisql, Enter the user ID, Password

Simple connection examples

You can include the -cparameter to specify connection parameters in the dbisql command, as described in the procedure above for connecting to UNIX. If you omit these parameters, the DBISQL logon window appears.

2Enter the user ID

DBA

and the password

SQL

This is the default user ID and password for Adaptive Server IQ databases when they are created.

3Click the Database tab and type the server name (for example, “ hostname_asiqdemo” for the asiqdemo database).

4If you use TCP/IP to connect to databases, on the Network tab, click on TCPIP. (If you use the shared memory port for connecting, skip this step.)

If your database is on a remote machine, you must add host information in the space beside TCPIP by typing “host= servername:nnnn” where servername is the name of your system and nnnn is your port number. (The default port number is 2638, but if the host was started with a different number, use that instead.)

5Click OK to connect to the database.

6After you connect to the database, the DBISQL window appears. The DBISQL window displays the database name, user ID, and server name for the connection on its title bar. The words “Connected to database” appear in the Statistics window along with a message displaying the collation sequence used by the database.

You can connect to any database server that is already running in the same manner. You can also specify a non-default character set and language.

For more information on using DBISQL, see the chapter “Getting Started with

DBISQL” in the Introduction to Adaptive Server IQ.

Connecting to other databases from DBISQL

The following procedure shows how to connect to a running database from

DBISQL.

56