Linux下配置PostgreSQL 的ODBC

Linux下安裝ODBC

1、在/etc目錄下修改odbc.ini、odbcinst.ini檔案
odbc.ini檔案中主要是設定資料庫串連
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 PostgresSQL
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