Interactive SQL Connection Parameters

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 only need to complete the User ID and Password fields if the IQ server was started on the local machine with IQTMP15 environment variable set. 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:
Note:

You can bypass the Connect window by supplying the connection parameters on the command line with the -c option.

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
Parent topic: dbisql Interactive SQL Utility
Related tasks
Starting Interactive SQL from Sybase Central
Starting Interactive SQL from a Command Prompt
Starting Interactive SQL from the Windows Start Menu
Related reference
Interactive SQL Command Line Options