On 2017/01/25 8:15, Inoue, Hiroshi wrote:
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.
Oops I made a mistake.
You can find the change in
https://github.com/hiinoue/psqlODBC.git in the branch pqopt.
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