When no database is connected, Sybase IQ displays the Connect window to request connection parameters. Information you enter in the Connect window is not preserved between sessions.
The connection parameters you specify in the Connect window are dependent on the number of databases running on the database server. To connect to a single database, you complete the User ID and Password fields. If there are multiple databases running on the database server, you must specify additional connection parameters such as the server or database name.
Enter connection parameters in the Connect window using one of these methods:
Use the Connect Assistant. See “Supplying connection parameters using the Connect Assistant”.
Manually enter connection parameters using the following tabs:
Identification tab– see “Supplying connection parameters: Identification tab”.
Database tab – see “Supplying connection parameters: Database tab”.
Network tab – see “Supplying connection parameters: Network tab”.
Advanced tab – see “Supplying connection parameters: Advanced tab”.
You can bypass the Connect window
by supplying the connection parameters on the command line with
the -c option as shown in “Command prompt examples (dbisql)”.
You can also click Cancel to start Interactive SQL with no database connected. You can then enter a CONNECT command in the SQL Statements window. For example, to connect to the sample database on a local server, you can use:
CONNECT USING 'UID=DBA;PWD=sql'
If the Connect window or an error message about missing information appears, you may need to enter the -host and -port or other missing information in the Advanced tab. If your database is on a remote server, enter the -host and -port parameters on separate lines, as in:
-host fiona -port 1870
For a complete list of connection parameters, see Chapter 4, “Connection and Communication Parameters” in the System Administration Guide: Volume 1.
After connecting to the database, the Interactive SQL utility appears.
