It seems the MySQL-ODBC-Driver is actually working fine; only setup a DSN isn't.
So install the MySQL Connector by ignoring the error messages and setup the DSN directly via regedit.exe like so:
Code:
------- MyDSN.reg ------------
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\ODBC]
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI]
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\MyDSN]
"DATABASE"="MyDatabase"
"Driver"="C:\\Program Files\\MySQL\\Connector ODBC 8.4\\myodbc8w.dll"
"NO_CATALOG"="0"
"NO_SCHEMA"="1"
"PORT"="3306"
"PWD"="MyPassword"
"SERVER"="MyServer"
"UID"="MyUsername"
-------------------------------
and you good to go.
Of course you have to replace the "My..." things to your settings and for future versions the path to the driver.
If your app still doesn't find the database use the Windows restart feature...