Bug #111698 MySQL for Excel: "The given key was not present in the dictionary"

• Submitted: 8 Jul 2023 13:45
• Modified: 12 Jul 2023 12:03
• Reporter: Luuk V
• Status: Unsupported
• Category: MySQL for Windows: MySQL for Excel
• Severity: S3 (Non-critical)
• Version: 1.3.8
• OS: Windows
• CPU Architecture: Any
• Tags: Excel

[8 Jul 2023 13:45] Luuk V

Description:
Install "MySQL for Excel" (https://dev.mysql.com/blog-archive/mysql-for-excel-1-3-8/), and added this to Excel 2013.

Trying to connect to a locally install MySQL Server version 8.0.33, throws:
"Connection attempt failed.", "The given key was not present in the dictionary"

How to repeat:
Try to access MySQL from Excel.

[12 Jul 2023 12:03] MySQL Verification Team

Hello Luuk,

Thank you for the bug report.
Please note that "MySQL for excel" is under sustaining support.

Learn how to connect Excel to MySQL
Search for 'Excel' in https://www.mysql.com/support/eol-notice.html

Regards,
Ashwini Patil

[20 Nov 2023 11:15] MySQL Verification Team

Bug #113134 marked as duplicate of this one.

[21 Dec 2023 13:24] MySQL Verification Team

Bug #113475 marked as duplicate of this one.

[21 Dec 2023 15:46] Ray Cheng

Hi there, is this bug fixed? As I can't find a solution through the answer here...

[23 Apr 12:33] MySQL Verification Team

Bug #115754 marked as duplicate of this one.