Centos7配置unixODBC连接远程informix

系统版本：

(venv) [root@centos etc]# cat /etc/os-release
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

unixODBC版本：

(venv) [root@centos etc]# odbcinst -j
unixODBC 2.3.1
DRIVERS............: /etc/odbcinst.ini
SYSTEM DATA SOURCES: /etc/odbc.ini
FILE DATA SOURCES..: /etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

ODBC驱动配置：

(venv) [root@centos etc]# cat /etc/odbcinst.ini 
[INFORMIX]
Driver=/opt/informix/lib/cli/iclit09b.so
Setup=/opt/informix/lib/cli/iclit09b.so
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=04.10
FileUsage=1
SQLLevel=1
smProcessPerConnect=Y

ODBC数据源配置：

(venv) [root@centos etc]# cat /etc/odbc.ini 
[carcb] 
Driver=INFORMIX
Description=INFORMIX
Database=testdb
LogonID=lubaohui
pwd=******
Server=xtdb
CLIENT_LOCALE=en_us.819
DB_LOCALE=en_us.819
TRANSLATIONDLL=/opt/informix/lib/esql/igo4a304.so

环境变量配置：

 1022  INFORMIXDIR=/opt/informix
 1023  INFORMIXSQLHOSTS=/opt/informix/etc/sqlhosts
 1024  ODBCINI=/etc/odbc.ini
 1025  LD_LIBRARY_PATH=${INFORMIXDIR}/ lib:${INFORMIXDIR}/ lib/cli:${INFORMIXDIR}/ lib/esql
 1026  export INFORMIXDIR INFORMIXSQLHOSTS ODBCINI LD_LIBRARY_PATH

测试连接：

[root@centos ibm_db-2.0.9]# isql carcb
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+