To add and configure a new ODBC data source in a Windows
environment, use the ODBC Data Source Administrator.
To open the ODBC Administrator from the Control Panel: Step 1: Right click Start > Control Panel. Step 2: Select Administrative Tools, then select ODBC Data
Sources (64 bits).
Step 3: In the ODBC Data Source
Administrator dialog box, click Add.
The Create New Data Source dialog box appears.
Step 4: Select a driver (e.g., PostgreSQL ODBC Driver) and
then click Finish.
The driver configuration dialog box appears.
Step 5: Complete the following field entries:
Data Source Name: enter the name of the data source you want to
access. It can be any valid name that you choose.
Description: enter the description needed for the data source.
Host or Server Name (or IP): enter the name of the PostgreSQL
server host that you want to access. By default, it is
localhost.
Database Name: enter the name of the PostgreSQL database that you
want to use as the default database.
User name: enter your PostgreSQL username (your database user
ID).
Password: enter your password.
Port: enter the port number if it is not the default value
(5432). Step 6: Click OK to add this data source.
