Connecting using an ODBC Data Source

Connect from Interactive SQL using an ODBC data source.

  1. Start Interactive SQL and open the Connect dialog (if it doesn’t appear automatically).
  2. On the Identification tab (Login tab in Interactive SQL Classic), enter a user ID and password, for example, DBA and sql.
  3. On the lower half of the Identification tab, do one of the following:
    • Select the ODBC Data Source Name option and specify a data source name (equivalent to the DSN connection parameter, which references a data source in the registry). To view a list of data sources, click Browse.

    • Select the ODBC Data Source File option and specify a data source file (equivalent to the FileDSN connection parameter, which references the data source held in a file.). You can search for a file by clicking Browse.

The SAP Sybase IQ Demo data source holds a set of connection parameters, including the database file and a start parameter.

Note: You can also specify the data source name by including the dsn connection parameter when you start Interactive SQL:
dbisql -c "dsn=Sybase IQ Demo"