Setting Up Data Sources

You will need to set up a data source name for any item you want to be able to access from Database Connectors for ODBC.

On Windows, use the ODBC Data Source Administrator to add a data source. The exact steps required for this will vary for each individual driver, but the general steps for setting up an ODBC data source are:

  1. Open the Windows control panel and click Administrative Tools.
  2. Double-click the ODBC Data Sources.

    The ODBC Data Source Administrator dialog is displayed. This dialog lists all the data sources currently configured for your system.

    Data Sources

  3. Double-click on the data source you plan to use to access a setup dialog. A subsequent window lets you add a description of the data source and allows you to supply other information the driver requires.

If the data source you want is not listed, choose Add to indicate which driver to use for the data source you will create. Remember, the exact steps required for setting up a driver vary greatly between drivers and driver vendors. Please refer to the driver’s documentation for precise details on this step. We recommend that you test the setup of your new data source. Many data sources come with a testing utility for this purpose.

On Linux and UNIX platforms, refer to the vendor instructions for the driver manager for details on how to add a data source.