Postgresql ODBC Driver Unicode 64 bit

E

EllenP1

Bit poster
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.
 
On my M3 MacBook I am running a 64 bits Windows 11 Pro VM. On this VM I've installed Power BI desktop, which is 64 bits.

Power BI can't use a 32-bit driver. So, how can the PostgreSQL 64-bits odbc driver properly installed on a ARM64 machine?
 
Frank van Zuilen (Pilares) said:
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
Click to expand...
I tried this workaround, but it didn't work for me. I can see the driver in Power BI, but when I try to use it, it throws the same 193 error.
@frank, did you do anything else to get the driver working in Power BI?
 
You must log in or register to reply here.
Back
Top