达梦数据库配置ODBC

1、LINUX环境中配置ODBC环境

[[email protected] installdoc]# tar -xzvf unixODBC-2.3.0.tar.gz 

[[email protected] installdoc]# cd unixODBC-2.3.0

[[email protected] unixODBC-2.3.0]# ./configure --enable-gui=no

[[email protected] unixODBC-2.3.0]# make

[[email protected] unixODBC-2.3.0]# make install

[[email protected] unixODBC-2.3.0]# odbc_config --version

2.3.0

[[email protected] unixODBC-2.3.0]# odbc_config --odbcini

/usr/local/etc/odbc.ini

 

修改配置文件

Odbc.ini

[dm7]

Desription=DM ODBC DSND

Driver = DM7 ODBC DRIVER

SERVER = localhost

UID = SYSDBA

PWD = dameng123

TCP_PORT = 5236

配置odbcinst.ini

[DM7 ODBC DRIVER]

Description = ODBC DRIVER FOR DM7

Driver = /dm7/bin/libdodbc.so

[[email protected] etc]# chmod 775 odbc.ini 

[[email protected] etc]# chmod 775 odbcinst.ini 

测试连接