Once a database server is running, you can connect to the server from dbisqlc. This example describes how to connect to the demo database iqdemo.
Starting dbisqlc and connecting to
a database from the command prompt
Ensure that the sample database is loaded on a running server, as described in “Starting the database server” in Chapter 3, “Running and Connecting to Servers” in the Introduction to Sybase IQ.
At the command prompt on your UNIX or Windows system, enter:
dbisqlc -c "uid=dba;pwd=sql"
The -c parameter specifies connection parameters. See Chapter 4, “Connection and Communication Parameters” in the System Administration Guide: Volume 1.
The default user ID and password for the iqdemo database
and other IQ databases are “dba” and “sql.” If
you have trouble connecting to a database, try changing the case
of the user ID and password that you supply.
Starting dbisqlc and connecting to a database
on Windows
Start the server, as described in “Starting the database server” in Chapter 3, “Running and Connecting to Servers” in the Introduction to Sybase IQ.
Select Start > Programs > Sybase > Sybase IQ 15.1 > Interactive SQL Classic.
The dbisqlc Connect window appears.
On the Login tab, enter the user ID:
dba
and the password:
sql
This is the default user ID and password for Sybase IQ databases when they are created. (The password does not appear when you type it.) By default, the password is case-sensitive for a case-sensitive database; the user ID is not.
Click the Database tab and type the server name (for example, “hostname_iqdemo” for the demo database). If your server is on a remote machine, make sure that you select “Search network for database servers.”
On the Network tab, select TCPIP.
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.)
Click OK to connect to the database.
