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'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 <?> 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 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--