andyxie407 发表于 2010-03-13 11:45

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

liaosnet 发表于 2010-03-13 11:57

Unable to load translation shared library (DLL).

:em26::em26:

andyxie407 发表于 2010-03-13 11:59

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

andyxie407 发表于 2010-03-13 12:10

-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的路径没有错误啊,我查了一下是存在的

大梦 发表于 2010-03-16 23:52

LD_LIBRARY_PATH环境变量没设吧?
页: [1]
查看完整版本: linux下用CSDK连接INFORMIX数据库,出现错误