Re: Root certificate not found

How do I get to that libpq file?

file?
How do you register ODBC DataSources?

regards,
Hiroshi Inoue

On Sun, May 5, 2019, 1:51 AM Inoue, Hiroshi <h-inoue@dream.email.ne.jp> wrote:

Hi Deon,

On 2019/05/02 8:52, Deon Bowers wrote:
> Hi, I'm trying to connect Excel to a PostgreSQL table and I ran across
> the psqlobdc file. When I attempt to setup the DSN it gives me this
> error "root certificate file .../postgresql/root.crt" does not exist.
>
> I'm using a .ca.cert file but your driver is looking for a root.crt file.
>
> How can I setup this up?

Could you set the datasource option using ODBC Data Source
administarator as follows?
Please set the libpq parameter of DataSource option 3 such as

     sslrootcert=C:\\some_folder .. \\.a.ca.cert

regards,
Hiroshi Inoue