为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8-x86-红帽7-64
【操作系统】:Ubuntu18.04
【CPU】:i7-6700HQ
【问题描述】*:isql 报错
isql dm -v
[S1000][unixODBC]Encryption module failed to load
[ISQL]ERROR: Could not SQLConnect
文件ODBC.in内容如下:
cat /etc/odbc.ini
[dm]
Description = DM ODBC DSN
Driver = DM8_ODBC_DRIVER
SERVER = localhost
UID = SYSDBA
PWD = SYSDBA
TCP_PORT = 5236
文件odbcinst.ini内容如下:
cat /etc/odbcinst.ini
[DM8_ODBC_DRIVER]
Description = ODBC DRIVER FOR DM8
Driver = /home/admin123/dmdbms/bin/libdodbc.so
将DM的bin目录加到系统中
cat /etc/ld.so.conf.d/dameng.conf
/home/admin123/dmdbms/bin
补充:
admin123@admin123-virtual-machine:~$ gedit .bashrc
admin123@admin123-virtual-machine:~$ source .bashrc
admin123@admin123-virtual-machine:~$ echo $LD_LIBRARY_PATH
/home/admin123/dmdbms/bin
admin123@admin123-virtual-machine:~$ tail .bashrc
#export QTINC=$QTDIR/include
#export QTLIB=$QTDIR/lib
export PATH=$QTDIR/bin:$PATH
#export LD_LIBRARY_PATH=$QTLIB
export QT_DEBUG_PLUGINS=1
LD_LIBRARY_PATH=/home/admin123/dmdbms/bin
admin123@admin123-virtual-machine:~$ isql dm -v
[S1000][unixODBC]Encryption module failed to load
[ISQL]ERROR: Could not SQLConnect
设置环境变量LD_LIBRARY_PATH=/home/admin123/dmdbms/bin:$LD_LIBRARY_PATH