In a 64-bit Windows environment, there is a clear distinction between 32-bit and 64-bit architecture. If your application (like the 64-bit version of Office 365) is 64-bit, it cannot use a 32-bit ODBC driver. It specifically requires the 64-bit version to function. Installing the wrong architecture is the most common cause of the "Data source name not found and no default driver specified" error. Where to Download 64-bit ODBC Drivers
Right-click the installer and select "Run as Administrator."
Grab the 64-bit (.msi or .exe) installer from the vendor's official site.
Look for the "MySQL Connector/ODBC." Ensure you select the x64 MSI installer.