通过ODBC连接DM数据库

环境说明

虚拟机版本：VMware® Workstation 15 Pro
系统版本：Linux localhost.localdomain 4.19.90-23.8.v2101.ky10.x86_64
数据库版本：DM8 / 1-1-172-21.02.01-134275-ENT
ODBC版本：unixODBC-2.3.0.tar.gz

ODBC 安装

预先将ODBC文件上传到目标服务器内

[root@localhost tool]# cd /opt/
[root@localhost opt]# ll
总用量 660932
-rw-r--r-- 1 root root 674988032  7月 28 02:10 dm8_20210222_x86_kylin10_64_ent_8.1.1.172.iso
drwxr-xr-x 2 root root        24  7月 28 01:10 firefox
drwxr-xr-x 4 root root        58  7月 28 01:09 patch_workspace
-rw-r--r-- 1 root root   1804749  7月 28 02:09 unixODBC-2.3.0.tar.gz
[root@localhost opt]# tar -zxvf unixODBC-2.3.0.tar.gz
...

[root@localhost opt]# ll
总用量 660936
-rw-r--r--  1 root root 674988032  7月 28 02:10 dm8_20210222_x86_kylin10_64_ent_8.1.1.172.iso
drwxr-xr-x  2 root root        24  7月 28 01:10 firefox
drwxr-xr-x  4 root root        58  7月 28 01:09 patch_workspace
drwxr-xr-x 19 1000 1000      4096  4月 20  2010 unixODBC-2.3.0
-rw-r--r--  1 root root   1804749  7月 28 02:09 unixODBC-2.3.0.tar.gz
[root@localhost opt]# cd unixODBC-2.3.0/
# 配置
[root@localhost unixODBC-2.3.0]# ./configure
# 编译
[root@localhost unixODBC-2.3.0]# make
# 安装
[root@localhost unixODBC-2.3.0]# make install
# 查看
[root@localhost unixODBC-2.3.0]# odbc_config --version
2.3.0

查看 ODBC 配置文件路径

[root@localhost unixODBC-2.3.0]# odbcinst -j
unixODBC 2.3.0
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
[root@localhost unixODBC-2.3.0]# 

编写odbc.ini，数据库的IP地址，端口号，用户名和密码等按照实际情况填写，以下作为参考。

[root@localhost unixODBC-2.3.0]# vi /usr/local/etc/odbc.ini 
[root@localhost unixODBC-2.3.0]# cat /usr/local/etc/odbc.ini 
[DM8]
Description = DM ODBC DSN
Driver = DM8 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = SYSDBA
TCP_PORT = 5236
[root@localhost unixODBC-2.3.0]# 

编写odbcinst.ini，libdodbc.so文件的路径以数据库安装路径为准

[root@localhost unixODBC-2.3.0]# vi /usr/local/etc/odbcinst.ini 
[root@localhost unixODBC-2.3.0]# cat /usr/local/etc/odbcinst.ini 
[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
Driver = /dm8/dmdbms/bin/libdodbc.so
[root@localhost unixODBC-2.3.0]# 

测试连接

使用dmdba用户进行连接

[root@localhost ~]# su - dmdba
上一次登录： 五 8月 20 17:38:36 CST 2021 pts/1 上
[dmdba@localhost ~]$ isql dm8 -v
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select status$ from v$instance;
+---------------------------------------------------------------------------------------------------------------------------------+
| STATUS$                                                                                                                         |
+---------------------------------------------------------------------------------------------------------------------------------+
| OPEN                                                                                                                            |
+---------------------------------------------------------------------------------------------------------------------------------+
SQLRowCount returns 1
1 rows fetched
SQL> 

使用账号密码方式登录

[dmdba@localhost ~]$ isql dm8 SYSDBA SYSDBA
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> select id_code;
+---------------------------------------------------------------------------------------------------------------------------------+
| ID_CODE                                                                                                                         |
+---------------------------------------------------------------------------------------------------------------------------------+
| 1-1-172-21.02.01-134275-ENT                                                                                                     |
+---------------------------------------------------------------------------------------------------------------------------------+
SQLRowCount returns 1
1 rows fetched
SQL> 

达梦技术社区：https://eco.dameng.com