项目场景:
达梦数据库安装ODBC驱动
安装环境:DM8+centos7.5
正常ODBC安装流程
[root@localhost ~]# rpm -qa |grep gcc
gcc-4.8.2- 16.el7.ns7.03.x86_64
[root@localhost ~]#rz -y
[root@localhost ~]# tar -xvf unixODBC-2.3.0.tar.gz
[root@localhost ~]# cd unixODBC-2.3.0/
[root@localhost unixODBC-2.3.0]# ./configure
[root@localhost unixODBC-2.3.0]# make && make install
[root@localhost unixODBC-2.3.0]# odbcinst -j
[root@localhost unixODBC-2.3.0]# vi /usr/local/etc/odbc.ini
[root@localhost unixODBC-2.3.0]# vi /usr/local/etc/odbcinst.ini
[dmdba@localhost ~]$ isql dm8
修改配置文件:odbc.ini与odbcinst.ini
odbc.ini修改:
odbcinst.ini修改:
ODBC无法正常通过isql dm8启动:
[dmdba@localhost ~]$ isql dm8
[ISQL]ERROR: Could not SQLConnect
解决方案:
[dmdba@localhost ~]$ cd
[dmdba@localhost ~]$ 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
[dmdba@localhost ~]$ source .bashrc
[dmdba@localhost ~]$ isql dm8 -v
+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL>