linux下用CSDK连接INFORMIX数据库，出现错误

andyxie407

dearl all ,

     我在red hat上面安装informix csdk2.90 UCR1,安装完成后，我运行
isql -v tccb_pcs出现下面的错误
[IM009][unixODBC][Informix][Informix ODBC Driver]Unable to load translation shared library (DLL).
[ISQL]ERROR: Could not SQLConnect
望大家指点迷津，谢谢

我的配置文件如下：

informix 用户环境变量
# User specific environment and startup programs

PATH=$PATHHOME/bin

export PATH
unset USERNAME

export INFORMIXDIR=/home/informix
export PATH=$PATHINFORMIXDIR/bin
export INFORMIXSERVER=tccb_pcs
export DB_LOCAL=en_us.8859-1
export LD_LIBRARY_PATH=$INFORMIXDIR/libINFORMIXDIR/lib/esqlINFORMIXDIR/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
;
;---------------------------------------------------------------------------
[ODBC Drivers]
informix=Installed

[informix]
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
;
;---------------------------------------------------------------------------
[ODBC Data Sources]
tccb_pcs=informix
Infdrv2=IBM INFORMIX ODBC DRIVER
;
; Define ODBC Database Driver's Below - Driver Configuration Section
;

[tccb_pcs]
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

[Infdrv2]
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

[ODBC]
;uncomment the below line for UNICODE connection
;UNICODE=UCS-4
Trace=0
TraceFile=/tmp/odbctrace.out
InstallDir=/extra/informix

liaosnet

Unable to load translation shared library (DLL).  

andyxie407

哥们，讲讲解决方法啊，谢谢

andyxie407

-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环境变量没设吧？