Re: Root certificate not found - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: Root certificate not found
Date
Msg-id 6f2609ba-48dd-21b8-bc0a-a3f964ee9a04@dream.email.ne.jp
Whole thread Raw
In response to Root certificate not found  (Deon Bowers <deandronbowers@gmail.com>)
List pgsql-odbc


On 2019/05/05 17:09, Deon Bowers wrote:
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


ウイルス フリー。 www.avg.com

pgsql-odbc by date:

Previous
From: Deon Bowers
Date:
Subject: Re: Root certificate not found
Next
From: Grant Shirreffs
Date:
Subject: Bound parameters in escaped functions