Re: [ODBC] Fwd: Connection string parameter sslrootcert does not work - Mailing list pgsql-odbc

From Inoue, Hiroshi
Subject Re: [ODBC] Fwd: Connection string parameter sslrootcert does not work
Date
Msg-id 94eae516-0160-e83c-7b78-ce769a34cb40@dream.email.ne.jp
Whole thread Raw
In response to Re: [ODBC] Fwd: Connection string parameter sslrootcert does not work  (Apurva Paralkar <apurva12mar@gmail.com>)
Responses Re: [ODBC] Fwd: Connection string parameter sslrootcert does not work  ("Inoue, Hiroshi" <h-inoue@dream.email.ne.jp>)
List pgsql-odbc
Hi Apurva,

On 2017/01/25 7:47, Apurva Paralkar wrote:
> Thanks for making the change, Hiroshi.
> We can move to using a different version of the driver. Do you know
> when this would be available for use?

I would push the change to official git if it is confirmed to be OK.

>
> Also, if the following string was the current connection string:
> Driver={PostgreSQL
>
Unicode(x64)};Server=<hostname>;Port=<port>;Database=<database-name>;UseDeclareFetch=1;Fetch=10000;Uid=username>;Pwd=****;sslmode=verify-ca;sslrootcert=<location

> of root.pem file on the client>
> what should the new connection string look like with your
> changes?Driver={PostgreSQL
>
Unicode(x64)};Server=<hostname>;Port=<port>;Database=<database-name>;UseDeclareFetch=1;Fetch=10000;Uid=username>;Pwd=****;sslmode=verify-ca;sslrootcert=<location

> of root.pem file on the client>

Driver={PostgreSQL

Unicode(x64)};Server=<hostname>;Port=<port>;Database=<database-name>;UseDeclareFetch=1;Fetch=10000;Uid=username>;Pwd=****;sslmode=verify-ca;pqopt={sslrootcert=<location

of root.pem file on the client>}

Note that the value of pqopt must be enclosed with braces.
Any libpq connection parameters can be specified in a pqopt option.

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Apurva Paralkar
Date:
Subject: Re: [ODBC] Fwd: Connection string parameter sslrootcert does not work
Next
From: "Inoue, Hiroshi"
Date:
Subject: Re: [ODBC] Fwd: Connection string parameter sslrootcert does not work