ODBC连接达梦数据库8

必须要有gcc环境变量
1.解压ODBC安装包

tar -xzvf unixODBC-2.3.0.tar.gz

2.配置ODBC

cd unixODBC-2.3.0/
./configure --enable-gui=no

3.编译ODBC

make
make install

4.查看ODBC的版本

odbc_config --version

5.查看ODBC配置文件的路径

odbc_config --odbcini
odbcinst -j

6.配置odbc.ini和odbcinst.ini

vi /usr/local/etc/odbc.ini

[dm8]
Description = DM ODBC DSND
Driver = DM8 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = dameng123
TCP_PORT = 5236

vi /usr/local/etc/odbcinst.ini

[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
DRIVER = /dm8/bin/libdodbc.so

7.测试是否成功

cd /dm8/bin
isql dm8