Defining an ODBC data source name

Edit online

About this task

After you determine the ODBC driver to use, complete the following steps to define the DSN.

To define an ODBC DSN, perform the following steps:

Procedure

  1. Select Settings > Control Panel > Administrative Tools > Data Sources (ODBD) the ODBC Data Source Administrator displays.
  2. Select the System DSN tab (not User DSN).
    Selecting System DSN lets you create a DSN that is visible to all users; selecting User DSN creates a DSN that is only visible to the specified user on a particular machine.
  3. Click Add.
    The Create a New Data Source Name window opens.
  4. Select the appropriate driver for your database from the list.
  5. Click Finish.
    The ODBC Setup window opens.
  6. Enter the driver-specific setup parameters.
    The name you assign in the Data Source Name window entry may be any name. However, IBM recommends that you use Trading_Manager_TEST (for testing) and Trading_Manager_PROD (for production) to simplify support and consulting consistency. The name entered will also be the selection for your DSN when you configure Partner Manager. You may enter an optional description in this window.
  7. Complete the window as required by the driver provider.
  8. Click OK.
  9. The name you assigned appears in the Name list in the ODBC Data Source Administrator.
  10. Click OK.