达梦配置odbc连接数据库

• 一、安装unixodbc
• 二、配置odbc配置文件
• 三、使用dmdba用户连接
• 四、使用root用户连接
• 总结

root用户源码安装

[root@localhost ~]# cd /usr/local
[root@localhost local]# tar -zxvf unixodbc-2.3.9.tar.gz
[root@localhost local]# cd unixodbc-2.3.9
[root@localhost unixodbc-2.3.9]# ./configure --enable-drivers=no --with-iconv-char-enc=GB18030 --enable-gui=no --enable-iconv=yes
[root@localhost unixodbc-2.3.9]# make
[root@localhost unixodbc-2.3.9]# make install

[root@localhost unixODBC-2.3.9]# odbcinst -j
unixODBC 2.3.9
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

[root@localhost ~]# vim /usr/local/etc/odbcinst.ini
[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
Driver = /home/dmdba/dmdbms/bin/libdodbc.so

[root@localhost ~]# vim /usr/local/etc/odbc.ini
[DM8]
Description = DM8 ODBC DSN
Driver = DM8 ODBC DRIVER
SERVER =192.168.10.58
UID = SYSDBA
PWD = SYSDBA
TCP_PORT = 5236

[root@localhost unixODBC-2.3.9]# su - dmdba

[dmdba@localhost ~]$ isql -v dm8
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit

[dmdba@localhost ~]$ cat ~/.bash_profile 
#.bash_profile
#Get the aliases and functions
if [ -f ~/.bashrc ]; then
	. ~/.bashrc
fi
User specific environment and startup programs
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/home/dmdba/dmdbms/bin"
export DM_HOME="/home/dmdba/dmdbms"

[root@localhost unixODBC-2.3.9]# vim /etc/profile
追加
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/home/dmdba/dmdbms/bin"
export DM_HOME="/home/dmdba/dmdbms"

[root@localhost unixODBC-2.3.9]# source /etc/profile
[root@localhost unixODBC-2.3.9]# isql -v dm8
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> quit

以上就是配置odbc连接数据库的流程

达梦社区地址：https://eco.dameng.com