通过配置unixODBC连接达梦数据库

1.下载unixODBC源码包
http://www.unixodbc.org/unixODBC-2.3.11.tar.gz
2.解压缩压缩文件

[root@localhost opt]# tar  -zxvf   unixODBC-2.3.11.tar.gz

3.源码安装三部曲（配置、编译、安装）

[root@localhost opt]# cd unixODBC-2.3.11/
[root@localhost unixODBC-2.3.11]# ./configure
[root@localhost unixODBC-2.3.11]# make
[root@localhost unixODBC-2.3.11]# make install

4.查看配置文件信息

[root@localhost unixODBC-2.3.11] odbcinst  -j
unixODBC 2.3.11
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

5.配置 odbc.ini 数据源信息和 odbcinst.ini 驱动信息

[root@localhost unixODBC-2.3.11]# cd /usr/local/etc/
[root@localhost etc]# ll
总用量 0
drwxr-xr-x 2 root root 6 12 月 22 16:56 ODBCDataSources
-rw-r--r-- 1 root root 0 12 月 22 16:56 odbc.ini
-rw-r--r-- 1 root root 0 12 月 22 16:56 odbcinst.ini
[root@localhost etc]# vim odbcinst.ini
[root@localhost etc]# vim odbc.ini
[root@localhost etc]# cat odbc.ini

[DM8]
Description = DM ODBC DSN
Driver = DM8 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = 123456789
TCP_PORT = 5236

[root@localhost etc]# cat odbcinst.ini
[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
Driver = /dm8/bin/libdodbc.so

6.测试

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

显示如上输出表示连接成功