Some users may prefer to use the older version of Interactive SQL that shipped with versions of IQ prior to 12.6. Once a database server is running, you can connect to it from dbisqlc. This example describes connecting to the sample database asiqdemo.
To start dbisqlc and connect 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” of the Introduction to Sybase IQ.
Start dbisqlc by entering:
dbisqlc -c "uid=DBA;pwd=SQL"
at the command prompt on your UNIX or Windows system.
The –c parameter specifies connection parameters. For a complete list of connection parameters, see Chapter 4, “Connection and Communication Parameters” in the Sybase IQ System Administration Guide.
The default user ID and password for the asiqdemo database and other
IQ databases are “DBA” and “SQL.” You must always type
the password in uppercase, because the default setting is CASE
RESPECT. (User IDs are never case sensitive.) However,
if you connect to a database created with Adaptive Server Anywhere,
the default may be lowercase. If you have trouble connecting to
a database, try changing the case of the user ID and password that
you supply.
To start dbisqlc and
connect to a database on Windows
Start the server, as described in “Starting the database server” in Chapter 3, “Running and Connecting to Servers” of the Introduction to Sybase IQ.
Select Start → Programs → Sybase → Adaptive Server IQ 12.6 → 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. This prevents someone else from seeing your password.) 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_asiqdemo” for the demo database).
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.
