ODBC

一、ODBC安装
1）UnixODBC安装
* yum安装
 
    # yum install -y unixODBC.x86_64

*
* 验证安装
 
    # rpm -qa | grep unixODBC
    unixODBC-2.3.1-11.el7.x86_64
2）PostgresqlODBC安装
* yum安装
 
    # yum install -y postgresql-odbc.x86_64

* 验证安装
 
    # rpm -qa | grep postgresql-odbc
    postgresql-odbc-09.03.0100-2.el7.x86_64

二、ODBC配置
1）查看odbcinst
# cat /etc/odbcinst.ini
~
[PostgreSQL]
D
Description = ODBC for PostgreSQL
D
Driver      = /usr/lib/psqlodbcw.so
S
Setup       = /usr/lib/libodbcpsqlS.so
D
Driver64    = /usr/lib64/psqlodbcw.so
S
Setup64     = /usr/lib64/libodbcpsqlS.so

FileUsage   = 1

2）配置odbc
# vim /etc/odbc.ini
~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[pg]
Description = Test to pg