Forum Discussion

comnot's avatar
comnot
Copper Contributor
Feb 03, 2022

ODBC Data Source ARM64 version could not create System DSNs

Hi, when I was trying to install PostgreSQL ODBC driver x64 version, I got a warning saying the driver could not be loaded due to system error code 193.  My winver is Win11 Version 21H2 (OS Bu...
genexx's avatar
genexx
Copper Contributor

matteosilva 

Works now:

Reinstalled the Win11 Arm on UTM VM:

 

  1. Just opened the 32 Bit ODBC Manager ( %systemdrive%\Windows\SysWoW64\odbcad32.exe )
  2. Installed MariaDB Connector/ODBC 32Bit

     

    Works for my Old VB6 Porgies / had to register missing *.dll:

     

    1. Open an elevated command prompt.
    2. If the 32-bit DLL is in the %systemroot%\System32 folder, move it to the %systemroot%\SysWoW64 folder.
    3. Run the following command:
      %systemroot%\SysWoW64\regsvr32 <full path of the DLL>

       

matteosilva

Ludelag's avatar
Ludelag
Copper Contributor
Mar 25, 2024

genexx

PROBLEM SOLVED! it was even not complicate to find the solution.

The executable odbcad32.exe.mui was missing in the file C:\Windows\SysWOW64 so, I found the file in the C:\Windows\System32 and copied as administrator and pasted in C:\Windows\SysWOW64, and the problem disappear, drivers working find and I could finally connect to the Database to work with BI.

  • kevin_marshbank's avatar
    kevin_marshbank
    Copper Contributor
    Sep 04, 2024

    Ludelag I found odbcad32.exe.mui under the en-US subfolder and copied it to C:\Windows\SysWOW64\en-US as well as to C:\Windows\SysWOW64.  Regardless, the postgresql ODBC driver failed to install.

    Were there any other steps involved? I am now trying a reboot.

  • Pilares_Frank's avatar
    Pilares_Frank
    Copper Contributor
    Oct 11, 2024

    Ludelag I've copied odbcad32.exe.mui to C:\Windows\SysWOW64.

    However I could not install the 64-bit version drivers for PostgreSQL (see for example PostgreSQL: File Browser), so what did you exactly do, because I need the 64 bit version to connect to a PostgesSQL database using Microsoft Power BI, which is 64 bits, because my Window 11 Pro is 64 bits.

    Running on a M3 Pro chip via Parrallels.

    • genexx's avatar
      genexx
      Copper Contributor
      Oct 11, 2024
      You should be able to have read that only a 32bit ODBC Driver could be installed and used on the Win 11 for Arm System 21H2.

      There seems to be a possibility to build / compile an 32bit Version from postgres ODBC Driver but that is not my field, so you may have to make some additional homework.

      I have now updated to 24H2 win11 for ARM Pro at UTM on MBA M2 and use still the 32Bit MariaDB ODBC driver with the VB6 Programm running via the registered VB6 dll reading from XAMPP MariaDB Database edited via HeidiSQL since Fall 2022.

      They have updated the Emulator Prism in 24H2.
      So you could try to Update to 24H2 and try the 64bit again.

      If that not works you have to go 32bit as we had to.
      • Pilares_Frank's avatar
        Pilares_Frank
        Copper Contributor
        Oct 12, 2024

        genexx 

         

        I used the workaround as described in ODBC 64 bit error 193 - Microsoft Q&A
        To summarize the workaround: configure with the 32-bits version first and then copy over the registry setting to the 64-bits version

Resources