达梦数据库DM8安装ODBC驱动无法正常连接

发布于:2024-07-02 ⋅ 阅读:(11) ⋅ 点赞:(0)

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