Compiling ODBC 12.0 on mac

From: Daniel Collins <dan(at)dcollins(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Compiling ODBC 12.0 on mac
Date: 2019-10-31 22:25:11
Message-ID: CANyDC1jE2Pcj6tb5XOJbeKpnen6783qpmHcY8v_ei45DKojzcg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-odbc by date

  From Date Subject
Next Message Christoph Berg 2019-11-07 08:51:53 Regression tests fail with PG12
Previous Message Inoue, Hiroshi 2019-10-17 15:07:40 Re: Compile Errors on Mac OS X 10.14.6 (fatal error: 'iODBC/sqltypes.h' file not found)