Linux下配置PostgreSQL 的ODBC

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