Configure PostgreSQL ODBC in Linux

Install ODBC in Linux

1. Modify the odbc. ini and odbcinst. ini files in the/etc directory.
The odbc. ini file mainly configures database connections.
Configure the database driver file in odbcinst. ini

Root @ wwww.bkjia.com:/etc # more odbc. ini
[Fsnhhb]
Description = For Nanhai, Foshan's smoke monitor
Driver = PostgreSQL
# Driver = enterprisedb
Trace = Yes
TraceFile =/tmp/SQL. log
Database = ZHDB
Servername = 127.0.0.1
UserName = epmonitor
Password = system
Port = 5444
Protocol= 7.4
ReadOnly = No
RowVersioning = No
ShowSystemTables = No
ShowOidColumn = No
FakeOidIndex = No
ConnSettings =
--------------------------------------------------------------------
Bkjia@wwww.bkjia.com:/etc $ more odbcinst. ini
[PostgreSQL]
Description = ODBC for PostgreSQL
Driver =/usr/lib/odbc/psqlodbca. so
Setup =/usr/lib/odbc/libodbcpsqlS. so
UsageCount = 1

[Enterprisedb]
Description = PostgresPlus Advanced Server ODBC driver
Driver =/opt/PostgresPlus/8.4AS/connectors/odbc/lib/edb-odbc.so
Setup =/opt/PostgresPlus/8.4AS/connectors/odbc/lib/libodbcedbS. so
UsageCount = 1