MySQL Connector / ODBC for Win 11 ARM

Confirmed it worked, thanks a lot ! My device is M4 Pro Macbook Pro and install an ARM64 windows 11 within parallel desktop. The odbcad32.exe in SysWOW64 is 32-bit program but it can add both 32-bit and 64-bit mysql odbc connector even the 64-bit connector installer shows error 193. Just ignore the error and it works in 64-bit excel data source.

 

For anyone still looking for a resolution... took me HOURS of research but finally was able to figure it out. For reference, I am connecting to SAP Business One on HANA but it should work for any data source (SQL, Oracle, etc.). My instructions are below:

Steps:

1. Install the 32 and 64-bit ODBC drivers you need (SQL Server, HDBODBC, etc.)
2. Open the 32-bit ODBC Administrator
   1. Run: C:\Windows\SysWOW64\odbcad32.exe
   2. Create your DSN using your installed driver.
3. Export the 32-bit DSN from the Registry
   1. Open regedit
   2. Navigate to: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI\<YourDSN>
   3. Right-click the folder, choose Export, and save it as a .reg file.
4. Edit the .reg file for 64-bit
   1. Open the .reg file in Notepad.
   2. Replace: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\ODBC\ODBC.INI\YourDSN
      with:HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\YourDSN
   3. Save the file.
5. Import the modified .reg file
   1. In Registry Editor, go to File > Import, and select the edited .reg file.
6. Map the DSN to its driver
   1. Go to: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources
   2. Right-click on ODBC Data Sources and choose > New > String Value
      • Name: YourDSN (whatever you named your connection in step 2b)
      • Value: Your driver name (e.g. HDBODBC, SQL Server, etc.)
7. Verify in 64-bit ODBC Admin
   1. Run: C:\Windows\System32\odbcad32.exe
   2. Your DSN should now be visible and usable in 64-bit applications like Excel or Power BI

Tip: Once it's working, export both:

• HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\<YourDSN>
• HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources

...as a backup .reg file for quick reuse later.