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

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

[root&＃64;localhost opt]# tar -zxvf unixODBC-2.3.11.tar.gz


3.源码安装三部曲&＃xff08;配置、编译、安装&＃xff09;

[root&＃64;localhost opt]# cd unixODBC-2.3.11/
[root&＃64;localhost unixODBC-2.3.11]# ./configure
[root&＃64;localhost unixODBC-2.3.11]# make
[root&＃64;localhost unixODBC-2.3.11]# make install


4.查看配置文件信息

[root&＃64;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&＃64;localhost unixODBC-2.3.11]# cd /usr/local/etc/
[root&＃64;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&＃64;localhost etc]# vim odbcinst.ini
[root&＃64;localhost etc]# vim odbc.ini
[root&＃64;localhost etc]# cat odbc.ini


[DM8]
Description &＃61; DM ODBC DSN
Driver &＃61; DM8 ODBC DRIVER
SERVER &＃61; localhost
UID &＃61; SYSDBA
PWD &＃61; 123456789
TCP_PORT &＃61; 5236


[root&＃64;localhost etc]# cat odbcinst.ini
[DM8 ODBC DRIVER]
Description &＃61; ODBC DRIVER FOR DM8
Driver &＃61; /dm8/bin/libdodbc.so


6.测试

[root&＃64;localhost ~]$ isql dm8 -v
&＃43;---------------------------------------&＃43;
| Connected! |
| |
| sql-statement |
| help [tablename] |
| echo [string] |
| quit |
| |
&＃43;---------------------------------------&＃43;
SQL>


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