About this task

When setting up the ODBC driver, configure the database to access a specific server.

When the ODBC driver is configured, it is accessible to ODBC-enabled applications on your computer. With ODBC, you can send queries to the CMS database from applications such as Microsoft Access. The query is used to access data and extract it for use in other applications.

Procedure

  1. From Control Panel, navigate to Set up ODBC Data sources (32-bit) or Set up ODBC Data sources (64-bit) as appropriate for your version of Windows.

    The ODBC Data Source Administrator window is displayed.

  2. Click one of the following tabs:

    • System DSN: Select this option if you want the data source to be available to all users. You need administrative privileges to create a system DSN.

    • User DSN: Select this option if you want the data source to be available to the current user. This setting is useful for providing access to a specific user. Do not administer data sources on a per-user login ID basis.

    • File DSN: Select this option if you want the data source to be stored in a file rather than the registry. This file will have a DSN extension.

  3. Click Add.

    The Create New Data Source window displays a list of data source drivers.

  4. Select the Informix ODBC driver.
  5. Do the following if you are using the File DSN tab:
    1. After selecting the driver, click Next.
    2. Browse to or type the name of the file data source.
    3. Click Next.
    4. Click Finish.

      The HCL Informix ODBC Driver Setup window is displayed.

  6. Do the following if you are using the User DSN or System DSN tab:
    1. After selecting the driver, click Finish to proceed with the setup.
    2. In the Data Source Name field, enter a name for the server or database you are connecting to.

      An example entry for this field is cms_net or cms_<hostname>, where <hostname> is the CMS hostname.

    3. In the Description field, enter a description for the data source you are connecting to.
    4. Click Connection tab.
    5. In the Server Name field, enter the CMS server name.

      Enter cms_<hostname> if you know the CMS hostname. Otherwise, you can enter cms_net. Note that you cannot connect to multiple CMS systems simultaneously using cms_net because the Server Name field requires a unique value across all DSNs. If you try to create another DSN using cms_net and provide a different hostname, it will change all DSNs with the same server name to use the new hostname.

    6. Enter the hostname or IP address.
    7. In the Service field, enter the port number for your database host machine.

      Use port 50000 for cms_net and port 50001 for cms_<hostname>.

    8. In the Protocol list, select olsocssl if ODBC TLS/SSL is configured on the CMS server.

      Otherwise, select olsoctcp.

    9. Leave the Options field blank.
    10. Enter cms in the Database Name field.
    11. Enter the CMS user ID and password.
  7. Click the Environment tab.
  8. Select the check box to the right of Use Server Database Locale.

    Note that you might need to change the Client Locale setting to en_US.UTF8 if the connection is not successful.

  9. Click the Connection tab.
  10. Click Apply.
  11. Click Apply & Test Connection and ensure that the connection is successful.
  12. Click OK as needed until the windows are closed.

    The ODBC driver software is installed on your computer.