Connecting To an Embedded Database From Interactive SQL in Windows

To connect to an embedded database, do the following:

  1. Start SAP Sybase IQ with no databases running. You can use either of the following ways:

    • From the Windows Programs menu, choose Sybase > Sybase IQ 16.0 > Interactive SQL, or,

    • Type dbisql at a system command prompt.

    When Interactive SQL starts, it is not connected to any database.

  2. Type CONNECT in the command window, and press F9 to execute the command. The connection dialog appears.
  3. If you have an ODBC data source for your database, select that data source.
  4. Enter DBA as the user ID and sql as the password. Then click the Database tab. Enter the full path of the demo database in the Database File field. For example, if your installation directory is c:\sybase\IQ-16_0, enter:
    c:\sybase\IQ-16_0\iqdemo.db
  5. Leave all other fields blank, and click OK. SAP Sybase IQ starts up and loads the demo database, and SAP Sybase IQ connects to the database.
Parent topic: Example: Connecting from Interactive SQL