Configuring Database Connections

There are two methods for connecting to the RDBMS; connection strings and using ODBC drivers. See Database Connections for more information.

For this example you will use ODBC drivers to connect to PostgreSQL:

  1. In the search field next to the start icon, type ODBC and click ODBC Data Sources (64-bit).

    This opens the ODBC Data Source Administrator (64-bit) application.

  2. Click System DNS tab.
  3. Click Add.

    This opens the Create New Data Source dialog box.

  4. Click PostgreSQL ODBC Driver(ANSI).
  5. Click Finish.

    This opens the PostgreSQL ANSI ODBC Driver (psqlODBC) Setup dialog box.

  6. Repeat the above steps and complete the details for the three databases listed below: