MySQL for Excel error
Posted by: Francisco Ignacio Fernandez Sanchez
Date: December 29, 2024 03:46AM

When running MySQL for Excel in Excel the following error occurs

Connection attempt failed

The key provided is not found in the dictionary.


Both MySQL and Excel are working and I can access from Excel to MySQL via ODBC.

I have disabled Firewall and Antivirus and it gives the same problem, reinstalled connectors and MySqServer, in the logs I do not see any related error.

With the user and password I can access from the Workbench and from other Data Sources via ODBC in Excel itself, the problem is only in the MySql for Excel component, I have tried with other previous versions and also give the same problem.


Does anyone have any idea what could be the problem?


The versions of the installed components are:

Windows 11 Home 24H2

MySQL Server MySQL Server 8.0.40

MySQL For Excel 1.3.8

MySQL Connector ODBC 9.1 (64 bits)

MySQL Connector NET 9.0.0

Microsoft® Excel® para Microsoft 365 MSO (versión 2411 compilación 16.0.18227.20082) de 64 bits 

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL for Excel error
821
December 29, 2024 03:46AM
322
February 12, 2025 07:15AM
339
March 26, 2025 12:51PM
326
March 26, 2025 12:52PM
11
June 19, 2025 06:47AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.