2.2. Configuring an ODBC Connection to xTuple

2.2. Configuring an ODBC Connection to xTuple
	2. What is ODBC?

2.2. Configuring an ODBC Connection to xTuple

After installing the PostgreSQL ODBC driver, it is time to configure it. This is a simple task. If you are running Windows, you perform the configuration by opening your Windows Control Panel, selecting Administrative Tools, and then Data Sources (ODBC), as shown in the following screen:

Configuring ODBC connection

On the ODBC Data Source Administrator panel, click the ADD button to begin configuring a connection to your xTuple PostgreSQL database. The following screen will appear:

Selecting PostgreSQL driver

Select the "PostgreSQL" driver from the list of available drivers and click the FINISH button. You will be presented with the following screen:

Final driver setup

When finalizing the set up of the PostgreSQL driver, you are presented with the following options:

Data Source: Give your connection a name (leave out spaces).
Description: Describe your connection.
Database: Enter the name of the PostgreSQL database.
Server: Provide the name or IP address of the PostgreSQL server.
Port: Enter the port on which the PostgreSQL database is listening.
User Name: Provide a database user's username.
Password: Provide the database user's password.

Now that our ODBC configuration is complete, we will use the connection to access data in an xTuple database.


2.1. Locating the ODBC Driver For PostgreSQL		3. Capturing SQL with MS Query

OpenRPT Product Guide

2.2. Configuring an ODBC Connection to xTuple