Fix for ODBC Error 193 When Creating 64-bit DSNs

Took me hours to find a figure out a fix for this so sharing in case it helps someone else!

Summary:
If you're using Windows 11 ARM (via Parallels) and get Error 193 when adding a 64-bit ODBC DSN, this guide walks you through creating a 32-bit DSN (Data Source Name), then converting it for 64-bit use. (For reference, I used this to create a DSN to SAP Business One on HANA which I then use in Excel's Power Query)

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.