Compiling ODBC 12.0 on mac

Daniel Collins <[email protected]> Thu, 31 Oct 2019 15:25:11 -0700
Newsgroups gmane.comp.db.postgresql.odbc
Message-ID <CANyDC1jE2Pcj6tb5XOJbeKpnen6783qpmHcY8v_ei45DKojzcg@mail.gmail.com>
--00000000000041ad4d05963c539e
Content-Type: text/plain; charset="UTF-8"

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

--00000000000041ad4d05963c539e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div>Hi friends,</div><div><br></div><div>My company uses =
Tableau, which bundles outdated psqlodbc drivers, and as such is proving a =
problem now that we&#39;ve migrated to PG12. For windows users I was able t=
o solve the problem with the msi installer eazy peazy. Mac not so much.</di=
v><div><br></div><div>I downloaded the PG12 main source and compiled, then =
ran the psqlodbc ./configure pointing to the main compiled source using --w=
ith-libpq, and a `make` and `sudo make install` later, I can see psqlodbcw.=
so, etc. in /usr/local/lib with fresh timestamps.</div><div><br></div><div>=
However, this new driver causes Tableau to spit out a gibberish error (unic=
ode &lt;?&gt; chars) on trying to connect, so something isn&#39;t right. I =
don&#39;t know if it&#39;s indicative of the problem, but if I run `make di=
stcheck` I get an error that pqlib is not found.</div><div><br></div><div>W=
hat is the best way to validate if the odbc driver is functional at a low l=
evel to see if my compiled driver is bad, or if Tableau is just being a jer=
k.</div><div><br></div><div>Cheers and Thanks,</div><div>Dan<br></div></div=
>

--00000000000041ad4d05963c539e--