达梦8到mysql8.0 创建DBLINK

软件准备

mysql 服务器搭建 通过docker  方式，

docker   pull mysql  

运行docker  服务。

docker run --restart=always --name=mysql -it -p 3307:3306 -e     MYSQL_ROOT_PASSWORD=123456 -d mysql

mysql-odbc的安装直接参考官方文档，以下是rpm的安装介绍，

MySQL :: MySQL Connector/ODBC Developer Guide :: 4.2.4 Installing Connector/ODBC from an RPM Distribution

odcb的配置

参考官网链接

MySQL :: MySQL Connector/ODBC Developer Guide :: 5.5 Configuring a Connector/ODBC DSN on Unix

unixodbc的安装过程参考下面的链接

Linux下ODBC安装配置_coco3600的博客-CSDN博客

实际的配置文件如下。

[dmdba@docker ~]$ cat /usr/local/etc/odbcinst.ini
[MySQL ODBC 8.0 Unicode Driver]
Driver=/usr/lib64/libmyodbc8w.so
#UsageCount=1

[MySQL ODBC 8.0 ANSI Driver]
Driver=/usr/lib64/libmyodbc8a.so
#UsageCount=1




[dmdba@docker ~]$ cat /usr/local/etc/odbc.ini
;
;;  odbc.ini configuration for Connector/ODBC 8.0 driver
;

[ODBC Data Sources]
myodbc8w     = MyODBC 8.0 UNICODE Driver DSN
myodbc8a     = MyODBC 8.0 ANSI Driver DSN

[myodbc8w]
Driver       = /usr/lib64/libmyodbc8w.so
Description  = Connector/ODBC 8.0 UNICODE Driver DSN
SERVER       = 192.168.159.128
PORT         = 3307
USER         = root
Password     = 123456
Database     = dameng
#OPTION       = 3
#SOCKET       =

[myodbc8a]
Driver       = /usr/lib64/libmyodbc8a.so
Description  = Connector/ODBC 8.0 ANSI Driver DSN
SERVER       = 192.168.159.128
PORT         = 3307
USER         = root
Password     = 123456
Database     = dameng
#OPTION       = 3
#SOCKET       =
[dmdba@docker ~]$

测试链接的过程截图。

create public link "LINK_MYSQLODBC" connect 'ODBC' with "dameng" identified by "******" using 'myodbc8w';

select * from "dameng"."dameng"@LINK_MYSQLODBC;

本文参考的链接 

 达梦到mysql的DBLINK_kevinlmlls的博客-CSDN博客