linux下用CSDK连接INFORMIX数据库,出现错误
dearl all ,我在red hat上面安装informix csdk2.90 UCR1,安装完成后,我运行
isql -v tccb_pcs出现下面的错误
Unable to load translation shared library (DLL).
ERROR: Could not SQLConnect
望大家指点迷津,谢谢
我的配置文件如下:
informix 用户环境变量
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
export INFORMIXDIR=/home/informix
export PATH=$PATH:$INFORMIXDIR/bin
export INFORMIXSERVER=tccb_pcs
export DB_LOCAL=en_us.8859-1
export LD_LIBRARY_PATH=$INFORMIXDIR/lib:$INFORMIXDIR/lib/esql:$INFORMIXDIR/lib/cli
export ODBCINI=/etc/odbc.ini
export CLIENT_LOCALE=en_us.8859-1
/home/informix/etc/sqlhosts文件
#demo_on onipcshm on_hostname on_servername
#demo_se seipcpip se_hostname sqlexec
tccb_pcs onsoctcp 14.1.78.5 8777
/usr/local/unixODBC/etc/odbcinst.ini
;---------------------------------------------------------------------------
; IBM INFORMIX ODBC Sample File
;
; File: odbcinst.ini
;
;---------------------------------------------------------------------------
informix=Installed
Driver=/home/informix/lib/cli/iclis09b.so (用这个iclit09b.so文件也试用)
Setup=/home/informix/lib/cli/iclis09b.so (用这个iclit09b.so文件也试用)
APILevel=1
ConnectFunctions=YYY
DriverODBCVer=03.51
FileUsage=0
SQLLevel=1
smProcessPerConnect=Y
/usr/local/unixODBC/etc/odbc.ini
;---------------------------------------------------------------------------
; IBM INFORMIX ODBC Sample File
;
; File: odbc.ini
;
;---------------------------------------------------------------------------
tccb_pcs=informix
Infdrv2=IBM INFORMIX ODBC DRIVER
;
; Define ODBC Database Driver's Below - Driver Configuration Section
;
Driver=/home/informix/lib/cli/iclis09b.so
Description= ODBC DRIVER
Database=pcsmain2_20091231
LogonID=pcs2
pwd=pcs2123
Servername=tccb_pcs
TRANSLATIONDLL=/home/informix/lib/esql/igo4a304.so
Driver=/extra/informix/lib/cli/iclis09b.so
Description=IBM INFORMIX ODBC DRIVER
Database=stores_demo
LogonID=odbc
pwd=odbc
Servername=ids_server2
CursorBehavior=0
CLIENT_LOCALE=en_us.8859-1
DB_LOCALE=en_us.8859-1
TRANSLATIONDLL=/extra/informix/lib/esql/igo4a304.so
;uncomment the below line for UNICODE connection
;UNICODE=UCS-4
Trace=0
TraceFile=/tmp/odbctrace.out
InstallDir=/extra/informix Unable to load translation shared library (DLL).
:em26::em26: 哥们,讲讲解决方法啊,谢谢 -11048 Unable to load translation shared library (DLL).
This IBM Informix CLI error code is the same as SQLSTATE value IM009. The
following functions can return this error code: SQLBrowseConnect(),
SQLConnect(), SQLDriverConnect(), and SQLSetConnectOption().
The driver is unable to load the translation DLL that is specified for
the data source or for the connection. Check that the name and path for
the DLL are correct.
官方给出的解释是,但是我的DLL的路径没有错误啊,我查了一下是存在的 LD_LIBRARY_PATH环境变量没设吧?
页:
[1]