Обсуждение: Root certificate not found

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


---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com

How do I get to that libpq file?

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