Share via

目前无法能过ODBC数据源来连接外网的mariadb数据库！总是提示错误说，无法用凭据验证！！！！版本是mariadb ODBC 3.1 Driver，在配置里面test是成功连接成功的，但在excel里面是无法连接成功！不知道是那里配置错了？

chinalin 0 Reputation points
2023-04-23T07:35:44.42+00:00

excel版本是2021版本！ 目前无法能过ODBC数据源来连接外网的mariadb数据库！总是提示错误说，无法用凭据验证！！！！ 版本是mariadb ODBC 3.1 Driver，在配置里面test是成功连接成功的，但在excel里面是无法连接成功！不知道是那里配置错了？ 1

4

Microsoft 365 and Office | Install, redeem, activate | For business | Windows
Microsoft 365 and Office | Excel | For business | Windows
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emily Hua-MSFT 27,796 Reputation points
    2023-04-24T02:55:53.69+00:00

    Hi @chinalin

    I suggest you try 32-bit ODBC driver to have a check.

    If it does not work, you may go to ODBC Data Source Administrator (32-bit) (C:\Windows\SysWoW64\odbcad32.exe) to remove it.

    Besides, as this issue may also be related to mariadb, it's recommended to contact support of mariadb. Thanks for your understanding.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.