Thread: Compiling ODBC 12.0 on mac

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