1.按操作手册安装完ODBC驱动后,连接提示报错如下:
[dmdba@localhost ~]$ isql dm8 -v
[01000][unixODBC][Driver Manager]Can't open lib '/dm8/bin/libdodbc.so' : file not found
[ISQL]ERROR: Could not SQLConnect
(isql dm8 -v,加-v是为了提示错误具体信息)
明明安装文件下有/dm8/bin/libdodbc.so这个文件,报这个错是,因为没有修改环境变量,修改环境变量操作如下:
注意在需要在dmdba账号下,配置环境变量参数
-------------------------------------------------------------------
cat>>$HOME/.bashrc<<EOF
export PATH
export DISPLAY=:0
export DM_HOME=/dm8
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/dm8/bin"
export PATH=$PATH:/$HOME/bin:$/HOME/.local/bin:$DM_HOME/bin
EOF
-----------------------------------------------------------
完成参数修改够,执行一些命更新环境变量:
source .bashrc
2.修改环境变量也可以在根目录 用vim编辑器修改,注意所在目录必须是根目录
[dmdba@localhost tool]$ cd
[dmdba@localhost ~]$ vim .bashrc
-----------------------------------------------------------------------------------------
export PATH
export DISPLAY=:0
export DM_HOME=/dm8
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/dm8/bin"
export PATH=$PATH:/$HOME/bin:$/HOME/.local/bin:$DM_HOME/bin
-------------------------------------------------------------------------------------
source .bashrc 完成参数修改够,执行一些命更新环境变量:
----------------------------------------------------------------------
3.ODBC驱动的配置文件
unixODBC安装:
tar -xzvf unixODBC-2.3.0.tar.gz
cd unixODBC-2.3.0
./configure --enable-gui=no
make && make install
查看ODBC版本
odbc_config --version
路径:
[root@localhost unixODBC-2.3.1]# odbcinst -j
修改配置文件
----------------------------------------------------------
cat>>/usr/local/etc/odbc.ini<<EOF
[DM8]
Description = DM ODBC DSN
Driver = DM8 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = Dameng123
TCP_PORT = 5238
EOF
---------------------------------------------
注意端口号和密码、路径
------------------------------------------------------------
cat>>/usr/local/etc/odbcinst.ini<<EOF
[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
Driver = /dm8/bin/libdodbc.so
EOF
---------------------------
注意用dmdba连接
[dmdba@localhost ~]$ isql dm8 -v