ODBC与JDBC连接DM7数据库

一、ODBC连接DM数据库

环境准备：

操作系统	RedHat6.8
数据库版本	DM7
必要组件版本	unixODBC-2.3.9

##在linux环境中配置ODBC
1.解压缩包
tar -xf unixODBC-2.3.9.tar.gz
cd unixODBC-2.3.9
2.配置与编译ODBC
./configure --enable-gui=no
make
make install
3.查看odbc版本与配置文件路径
[root@localhost unixODBC-2.3.9]# odbc_config --version
2.3.9
[root@localhost unixODBC-2.3.9]# odbc_config --odbcini
/usr/local/etc/odbc.ini
[root@localhost unixODBC-2.3.9]# odbcinst -j
unixODBC 2.3.9
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
4.配置odbc.ini和odbcinst.ini文件
vi /usr/local/etc/odbc.ini
[dm]
Description = DM ODBC DSN
Driver = DM7 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = SYSDBA
TCP_PORT = 5236

vi /usr/local/etc/odbcinst.ini
[DM7 ODBC DRIVER]
Description = ODBC DRIVER FOR DM7
Driver = /home/dmdba/dm/dmdbms/bin/libdodbc.so

5.修改配置文件权限
chmod 775 /usr/local/etc/odbcinst.ini
chmod 775 /usr/local/etc/odbc.ini

6.切换为dmdba用户做登入测试
[root&#