达梦数据库DM7在LINUX中配置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版本

修改配置文件

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

测试连接
达梦数据库DM7在LINUX中配置ODBC

直接登录

密码方式登录