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.
I was having this problem on my Win 11 64 ARM VM when trying to set up a Snowflake driver. I noticed that the links in the Start Menu for 32 and 64 both point to the same, wrong executable for the ODBC Administrator console. The right one is C:\Windows\SysWOW64\odbcad32.exe . When I ran that I was able to set up the driver and use it properly.
Checking again just now, I see that in fact this is the 32 bit interface (WOW64 = Windows 32 Bit on 64 Architecture), so you will indeed need the 32 bit driver.