手抄报 安全手抄报 手抄报内容 手抄报图片 英语手抄报 清明节手抄报 节约用水手抄报

Informix客户端安装步骤

时间:2024-10-13 21:11:14

1、下载clientsdk.3.50.FC2DE.LINUX.tar(Linux system for x86-64,RedHat)上传到服务器解压tar -xvf clientsdk.3.50.FC2DE.LINUX.tar

Informix客户端安装步骤

2、安装./installclientsdk如果报错,请使用如下命令./installclientsdk -javahome none

Informix客户端安装步骤

3、选择安装目录这个可以看自己的习惯,这里使用如下目录/opt/IBM/informix

Informix客户端安装步骤

4、切换到目录/etc,在文件services中末尾添加informix映射端口,格式为:(端口名称) 端口及协议) # Informix Serveradr_port 9986/tcp

Informix客户端安装步骤

5、切到目录/opt/IBM/informix/etc,在文件sqlhosts中添加一个新的数据库连接,格式是:(名称) (tcp协议) (服务器地址)(端口名称)online_adr1 onsoctcp 192.168.1.131 adr_port

Informix客户端安装步骤

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目录下

Informix客户端安装步骤
Informix客户端安装步骤

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

Informix客户端安装步骤

8、安装头文件开发包unixODBC-devel-2.2.14-14.el6.x86_64.rpm使用命令:rpm -iv unixODBC-devel-2.2.14-14.el6.x86_64.rpm。已安装了unixODBC可省略此步。

Informix客户端安装步骤

9、测试,其中test为odbc.ini中[test]的test$>isql test-v 回车,出现:+-------------幻腾寂埒--------------------------+| Connected! || || sql-statement || help [tablename] || quit || |+---------------------------------------+SQL>然后就可以进行操作了具体参见:How To Setup Generic Connectivity - HSODBC - on Linux

Informix客户端安装步骤
© 手抄报圈