1、下载clientsdk.3.50.FC2DE.LINUX.tar(Linux system for x86-64,RedHat)上传到服务器解压tar -xvf clientsdk.3.50.FC2DE.LINUX.tar
2、安装./installclientsdk如果报错,请使用如下命令./installclientsdk -javahome none
3、选择安装目录这个可以看自己的习惯,这里使用如下目录/opt/IBM/informix
4、切换到目录/etc,在文件services中末尾添加informix映射端口,格式为:(端口名称) 端口及协议) # Informix Serveradr_port 9986/tcp
5、切到目录/opt/IBM/informix/etc,在文件sqlhosts中添加一个新的数据库连接,格式是:(名称) (tcp协议) (服务器地址)(端口名称)online_adr1 onsoctcp 192.168.1.131 adr_port
6、切换到目录/opt/IBM/informix/etc,修改文件odbc.ini,odbcinst.ini的内容,举例:##编辑odbc.ini#>vi odbc.ini;------幻腾寂埒---------------------------------------------------------------------; IBM INFORMIX ODBC Sample File;; File: odbc.ini;;---------------------------------------------------------------------------[ODBC Data Sources]cbs=IBM INFORMIX ODBC DRIVERInfdrv2=IBM INFORMIX ODBC DRIVER;; Define ODBC Database Driver's Below - Driver Configuration Section;[test]Driver=/opt/IBM/informix/lib/cli/iclit09b.soDescription=IBM INFORMIX ODBC DRIVERDatabase=testLogonID=adminpwd=adminServername=online_adr1CursorBehavior=0CLIENT_LOCALE=en_us.8859-1DB_LOCALE=en_us.8859-1TRANSLATIONDLL=/opt/IBM/informix/lib/esql/igo4a304.so;; UNICODE connection Section;[ODBC];uncomment the below line for UNICODE connection;UNICODE=UCS-4;; Trace file Section;Trace=0TraceFile=/tmp/odbctrace.outInstallDir=/opt/IBM/informixTRACEDLL=idmrs09a.so##编辑另外一个文件odbcinst.ini#>vi odbcinst.ini---------------------------------------------------------------------------; IBM INFORMIX ODBC Sample File;; File: odbcinst.ini;;---------------------------------------------------------------------------[IBM INFORMIX ODBC DRIVER]Driver=/opt/IBM/informix/lib/cli/iclit09b.soSetup=/opt/IBM/informix/lib/cli/iclit09b.soAPILevel=1ConnectFunctions=YYYDriverODBCVer=03.51FileUsage=0SQLLevel=1smProcessPerConnect=Y##将以上两个文件odbc.ini,odbcinst.ini拷贝到/etc目录下
7、添加到环境变量$>vi /etc/profileexport INFORMIXDIR=/opt/IBM/informixexport ODBCINI=/etc/odbc.iniexport ODBCINSTINI=/etc/odbcinst.iniexport PATH=$PATH:/opt/IBM/informix/binexport LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql
8、安装头文件开发包unixODBC-devel-2.2.14-14.el6.x86_64.rpm使用命令:rpm -iv unixODBC-devel-2.2.14-14.el6.x86_64.rpm。已安装了unixODBC可省略此步。
9、测试,其中test为odbc.ini中[test]的test$>isql test-v 回车,出现:+-------------幻腾寂埒--------------------------+| Connected! || || sql-statement || help [tablename] || quit || |+---------------------------------------+SQL>然后就可以进行操作了具体参见:How To Setup Generic Connectivity - HSODBC - on Linux