Creating a Data Source from the ODBC Administrator

The ODBC Administrator provides an easy way to create an ODBC Data Source.

  1. Start the ODBC Administrator:

    Select Settings > Control Panel > Administrative Tools > Data Sources (ODBC).

    or

    Sybase IQ 16.0 > ODBC Administrator 32-bit

    The ODBC Data Source Administrator appears.

  2. Click Add.

    The Create New Data Source wizard appears.

  3. Select the SAP Sybase IQ from the list of drivers and click Finish.
  4. In the ODBC Configuration window, type the Data Source Name.
  5. Now click the Login tab. Type the User ID and Password for your database. For example, use DBA and sql.
  6. Click the Database tab. If the data source is on your local machine, type the Server name, a Start line and Database file, including the path.
  7. If the data source is on a remote system, click the Network tab. Click the box for the appropriate protocol and specify the options beside the box. For example, to connect to a server using TCP/IP protocol and port 1870, you would click TCP/IP and type:
    port=1870
  8. Click OK when you have finished defining your data source.

    The ODBC Data Source Administrator returns you to the User DSN tab.

Note: When specifying network connections, you need a different systemname:port# combination for each database server. The port number must match the one you started the server with.
Parent topic: ODBC Data Sources