Connecting from a Windows System

Connect to a running database from the Start menu or command prompt.

1. Choose Programs > Sybase > Sybase IQ 16.0 > Interactive SQL, or at the Windows command prompt, enter:

   dbisql

   You can include the -c parameter to specify connection parameters in the dbisql command. If you omit these parameters, the Interactive SQL connect dialog appears.

2. In the Connect dialog, enter your user name and password.

   For example, for the iqdemo database, enter DBA and sql, the default user and password combination for SAP Sybase IQ databases when they are created.

3. Click the Database tab and type the server name that was used to start the server (for example, “hostname_iqdemo” for the iqdemo database). This name must be unique on your local area network.

   For remote servers, specify the server as host name and port number on the Network tab.

   The default port number is 2638, but if the server was started with a different number, use that instead. You can find the port number by running Sybase IQ 16.0 > ODBC Administrator 32-bit or Sybase IQ 16.0 > ODBC Administrator 64-bit. Select the User Data Sources on the User DSN tab, then click Configure. Enter dblocate at the command prompt.

   This procedure connects you to the first database started on this server. If more than one database is running, you may need to click Browse to select the database you want.

4. Click OK to connect to the database.
   If you see the Connect dialog or an error message about missing information, 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, for example:

   -host fiona
   -port 1870

5. After you connect to the database, the Interactive SQL window appears. The database name, user ID, and server name for the connection appear on its title bar.

   If you connect using Interactive SQL Classic, you see Connected to database in the Statistics window, along with a message that shows the collation used by the database.