Thread: Root certificate not found
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?
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
---
このメールは、AVG によってウイルス チェックされています。
http://www.avg.com
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