17.2 Configuring an ODBC Connection

You need to set the ODBC.ini file as showin the following example:
scott@lc10ujz Postgres> cat odbc.ini
[ODBC Data Sources]
PGDSN=DataDirect 7.1 PostgreSQL Wire Protocol
postgres=DataDirect 7.1 PostgreSQL Wire Protocol
scott=DataDirect 7.1 PostgreSQL Wire Protocol
[ODBC]
IANAAppCodePage=4
InstallDir=/scott/work/Postgres/7.1
[PGDSN]
Driver=/scott/work/Postgres/7.1/lib/GGpsql25.so
Description=DataDirect 7.1 PostgreSQL Wire Protocol
Database=postgres
HostName=localhost
#HostName=10.250.57.112
PortNumber=5432
LogonID=postgres
Password=welcome

Also see Configuring Manager.