On Windows, you can start Interactive SQL from
the Sybase IQ Program Group.
- Click .
- On the Identification tab, enter DBA in
the User box, and sql in the Password
box.
This is the default user ID and password for Sybase IQ databases. DBA is not
case-sensitive; sql is case-sensitive, and must appear in all lowercase letters.
- On the Database tab, choose a server from the Server
name box. Click Find to search for running servers.
Server names appear in this format <hostname>_dbname.
If the host name is localhost-xp and you are
running the sample iqdemo database, the server
name would be localhost-xp_iqdemo.
If the server is remote, type host:port instead
of the server name.
- Choose a database from the Database name box.
When there
is only one database running, you can leave this field blank.
- What you do next depends on the server location:
- To run Interactive SQL against a server installed
on the same machine, you must also choose an appropriate Database
file.
- To run Interactive SQL against a network server,
click the Network tab, click the TCP/IP box, then specify
the Host name and Port number.
- Click OK.
Other applications connect to the database server in much
the same way. To make the connection, they must submit both user
ID and password. The Utility Guide gives more
details about how to use Interactive SQL.