Share via

Issue with the MySQL ODBC Driver for Microsoft Excel

Anonymous
2022-03-25T17:06:49+00:00

Hi,

I am trying to connect to a MYSQL database from Excel. Even after installing the recommended MYSQL ODBC drivers I'm unable to get excel to recognize it. Excel keeps telling me to install 'additional components' the component being this ODBC Driver. I even tried previous versions of the driver but it isn't of any use. This is the error I get.

These are the drivers I've installed and tried to work with: downloaded from here -> https://dev.mysql.com/downloads/connector/odbc/

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

20 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-07T19:20:42+00:00

    I headed over the MySQL bug tracker and found this one: MySQL Bugs: #107316: MySQL 8.0.29 introduces a bug which prevents use of the Connector software

    Based on that, and the hidden documentation to additionally install the ADO.NET connector, I've finally got this working with 64-bit Excel 365 by installing the 64-bit ODBC Connector, version 8.0.28, and the 32-bit ADO.NET connector, version 8.0.28.

    Note that there is only a 32-bit ADO.NET connector available, as discussed above.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-08-04T14:51:21+00:00

    I have come to learn more about my situation. This had been working, without need for me to create DSN files. Then there were changes made by IT on Cyberark that coincide with the introduction of the problem.

    I worked with out IT folks to see if they could tweak Cyberark to make it work. They couldn't figure it out.

    Then another person in the group found that he could do

    Data--> Get Data --> From Other Source (DO NOT USE FROM DATABASE) --> From ODBC and create a DSN file.

    This means the existing functionality is broken and spread sheets with such data pulls cannot be shared without sharing the DSN file.

    So it works but it is very kludgy.

    Of course Microsoft will say not their problem and IT /CyberArk folks will say not their problem and there is little to look at to debug exactly what is going on.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments
  3. Anonymous
    2022-09-02T22:10:47+00:00

    Thank you very Much Jordan,

    I also was able to get mine Excel x64 O365 working using the version 8.0.28 as informed by you.

    Saved my day.

    Thx,

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  4. Anonymous
    2022-08-04T14:07:48+00:00

    I'm also having this problem, running Microsoft® Excel® for Microsoft 365 MSO (Version 2206 Build 16.0.15330.20260) 64-bit under Windows 11.

    The MS docsdon't say anything about needing to create a DSN after installing the drivers. That said, I've tried it, and get the same result.

    @Gerhard, I notice that when regardless of whether I install the 32- or 64-bit connector, the MySQL ODBC Connector only appears in the Add list for C:\WINDOWS\SYSTEM32\odbcad32.exe, not C:\WINDOWS\SYSWOW64\odbcad32.exe.

    I also notice that under C:\WINDOWS\SYSTEM32\odbcad32.exe, I am given the option to user either the ANSI and Unicode driver. Should it matter? Cross-posted over on Superuser.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2022-03-25T17:27:42+00:00

    Hello.

    Did you set up the DSN in windows (see MySQL :: MySQL Connector/ODBC Developer Guide :: 5.3.1 Configuring a Connector/ODBC DSN on Windows with the ODBC Data Source Administrator GUI)

    To set up DSN for 32-bit on 32-bit machine or 64-bit on 64-bit machine use C:\WINDOWS\SYSTEM32\odbcad32.exe

    To set up DSN for 32-bit on 64-bit machine use C:\WINDOWS\SYSWOW64\odbcad32.exe

    Which version you need depends on which version of office you are using (32-bit or 64-bit), but you may set up both ...

    See also MySQL :: MySQL Connector/ODBC Developer Guide :: 6.5 Using Connector/ODBC with Microsoft Word or Excel.

    Kind Regards

    Gerhard

    Was this answer helpful?

    0 comments