MySQL Connector / ODBC for Win 11 ARM

Al_17 said:
Maybe this saves someone a lot of time..
after half a day of try-and-fail I finally did it! and it's actually quite easy
I wasn't able to install 32bit msaccess for some reason, no matter how hard I was trying.
so
Need to install BOTH ODBC 32bit AND 64bit driver:
https://downloads.mysql.com/archives/c-odbc/ - use version 8.0.32 as it has both 32 AND 64 bit. (you will need visual c++ redistributable for 32bit version)
When installing 64bit - ignore the error
then set up ODBC connection via 32bit app: \Windows\SysWOW64\odbcad32.exe
then that's it. works with msaccess 64 bit as a charm!
Click to expand...
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.
 
You must log in or register to reply here.
Back
Top