Compiling ODBC 12.0 on mac - Mailing list pgsql-odbc

From Daniel Collins
Subject Compiling ODBC 12.0 on mac
Date
Msg-id CANyDC1jE2Pcj6tb5XOJbeKpnen6783qpmHcY8v_ei45DKojzcg@mail.gmail.com
Whole thread Raw
List pgsql-odbc
Hi friends,

My company uses Tableau, which bundles outdated psqlodbc drivers, and as such is proving a problem now that we've migrated to PG12. For windows users I was able to solve the problem with the msi installer eazy peazy. Mac not so much.

I downloaded the PG12 main source and compiled, then ran the psqlodbc ./configure pointing to the main compiled source using --with-libpq, and a `make` and `sudo make install` later, I can see psqlodbcw.so, etc. in /usr/local/lib with fresh timestamps.

However, this new driver causes Tableau to spit out a gibberish error (unicode <?> chars) on trying to connect, so something isn't right. I don't know if it's indicative of the problem, but if I run `make distcheck` I get an error that pqlib is not found.

What is the best way to validate if the odbc driver is functional at a low level to see if my compiled driver is bad, or if Tableau is just being a jerk.

Cheers and Thanks,
Dan

pgsql-odbc by date:

Previous
From: "Inoue, Hiroshi"
Date:
Subject: Re: Compile Errors on Mac OS X 10.14.6 (fatal error:'iODBC/sqltypes.h' file not found)
Next
From: Christoph Berg
Date:
Subject: Regression tests fail with PG12