From: | "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp> |
---|---|
To: | Apurva Paralkar <apurva12mar(at)gmail(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Fwd: Connection string parameter sslrootcert does not work |
Date: | 2017-01-24 23:15:29 |
Message-ID: | 94eae516-0160-e83c-7b78-ce769a34cb40@dream.email.ne.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Inoue, Hiroshi | 2017-01-25 10:06:01 | Re: Fwd: Connection string parameter sslrootcert does not work |
Previous Message | Apurva Paralkar | 2017-01-24 22:47:10 | Re: Fwd: Connection string parameter sslrootcert does not work |