Use Postgres ODBC in MacOS's Microsoft Office Excel

From: Alexander Yi <alexander(dot)yi(at)technest(dot)es>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Use Postgres ODBC in MacOS's Microsoft Office Excel
Date: 2024-02-26 06:59:53
Message-ID: 966DD21C-C1D0-44F6-81E3-19CC4F4AE9E9@technest.es
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Dear supporters in the community,

Recently I was working on invoking PGSQL query at MS Excel installed in MacOS,
but I failed to achieve iot due to an issue,
which is the sandbox mechanism in MacOS that block the dynamic library access located in other directory.

So I believe the only way to make it work is to build my own Postgres ODBC,
which make my Postgres ODBC have static libpq library, instead of dynamically accessing it from some path like /usr/local/opt/libpq/lib/libpq.5.dylib

Actually I'm not sure if this is a correct solution or not, and I got no clue to achieve my hypothetical approach.
So hope I can seek some advice here,

Thanks for reading my question.

BR. Yi

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Cramer 2024-02-26 20:11:14 Re: psqlodbc crashes while collecting diagnostic records with SQLGetDiagRecW
Previous Message Andrey Sukhanov 2024-02-22 06:29:35 psqlodbc crashes while collecting diagnostic records with SQLGetDiagRecW