注册

DM8使用DMHS工具同步MYSQL8数据,源端copy操作报错:Can't open lib 'MySQL ODBC Driver'

DM_12128 2024/03/29 546 1

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:CentOS7
【CPU】:AMD
【问题描述】*:DM8使用DMHS工具同步MYSQL8数据,源端copy操作导致报错:Can't open lib 'MySQL ODBC Driver'
image.png
我的ODBC可以正常驱动

[root@localhost1 bin]# isql -v mysql
+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL>
[root@localhost1 etc]# cat odbc.ini 
[mysql]
Driver=MySQL ODBC Driver
DATABASE=mysql
DESCRIPTION=MySQL ODBC Driver
SERVER=172.20.10.201
PORT=3306
UID=root
PASSWORD=abc123
[root@localhost1 etc]# cat odbcinst.ini 
[MySQL ODBC Driver]
DRIVER=/usr/local/mysqlODBC/lib/libmyodbc8w.so
UsageCount=1
[root@localhost1 bin]# odbcinst -j
unixODBC 2.3.1
DRIVERS............: /usr/local/unixODBC/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/unixODBC/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/unixODBC/etc/ODBCDataSources
USER DATA SOURCES..: /root/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8

是有什么路径没配置吗?

回答 0
暂无回答
扫一扫
联系客服