Hello, I am having many troubles setting up the Postgresql ODBC Unicode64 Driver on the VM. I am working on Mac M1 and windows 11. I am wondering if this issue is linked to the windows ARM. I have downloaded the most recent ODBC driver from Postgres called - psqlodbc_13_02_0000-x64 and then in trying to install I get the error "Error install ODBC Driver: PostgreSQL ANSI 64 ODBC error 13 The setup routines for the PostgreSQL ANSI 64 ODBC driver could not be installed due to system error 193. Verify that the file Postgresql ANSI 64 exists and you can access it" In looking into the ANSI related topics it seems like there is a lack in the ARM configuration. But this is just a wild guess. Is there a solution?
I was able to get it to work by using the odbcad32.exe app from the Windows\SysWOW64 folder. You need to use a 32-bit driver for it to work.
Windows 11 has regressed to need a redistributable and visual studio setup as pre-requirements to install MySQL Connector ODBC 64. ODBC 64 is required for all modern Office programs. Installing redistributable and VS Setup on a windows machine is straightforward. Installing them on Parallels is impossible. For our customers, we're recommending they avoid Windows 11 until either Microsoft changes or Parallels changes. It will be interesting to see which is more responsive to its customers.