Configuring an ODBC Datasource on Windows

ODBC lets you use clients with the demo database.

StepsConfiguring an ODBC Datasource on Windows

The following examples shows you how to set up an ODBC datasource name (DNS).

  1. On the ODBC tab, specify the name of the ODBC datasource that the ODBC administrator can access.

    Figure 25: ODBC tab

    The ODBC tab is selected and shows the Data Source Name Sybase IQ Demo and Description Sybase IQ Demo Database.
  2. On the Login tab, specify the User ID and password associated with this connection to IQ. If you are using the IQ demo database, specify User ID DBA and Password sql.

    Figure 26: Login tab

    The Login tab is selected and shows User ID DBA and Password hidden by asterisks.
  3. On the Database tab, specify the name of the server and database file. The server name is assigned when IQ starts with the -n parameter. The database file is the fully qualified location of the database file name associated with this connection to IQ.

    Figure 27: Database tab

    The Database tab is selected and shows Server name iqdemo and the Database file path.  Start Database Automatically is checked.
  4. On the Network tab, specify the network protocols and options. The TCP/IP options you need are host (<yourhost>) and port (2638). The IQ server assigns the port option when it starts, and the host is the physical host on which the IQ server is running.

    Figure 28: Network tab

    The Network tab is selected with the TCP/IP box checked. TCP parameters are typed in the space provided.