通过ODBC连接DM数据库

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

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

[root&＃64;localhost tool]# cd /opt/
[root&＃64;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&＃64;localhost opt]# tar -zxvf unixODBC-2.3.0.tar.gz
...


[root&＃64;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&＃64;localhost opt]# cd unixODBC-2.3.0/
# 配置
[root&＃64;localhost unixODBC-2.3.0]# ./configure
# 编译
[root&＃64;localhost unixODBC-2.3.0]# make
# 安装
[root&＃64;localhost unixODBC-2.3.0]# make install
# 查看
[root&＃64;localhost unixODBC-2.3.0]# odbc_config --version
2.3.0


查看 ODBC 配置文件路径

[root&＃64;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&＃64;localhost unixODBC-2.3.0]#


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

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


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

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

测试连接

使用dmdba用户进行连接

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

使用账号密码方式登录

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


达梦技术社区&＃xff1a;https://eco.dameng.com