SSL with Access VBA

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: PostgreSQL mailing lists <pgsql-odbc(at)postgresql(dot)org>
Subject: SSL with Access VBA
Date: 2016-11-09 18:51:54
Message-ID: a3ffab2a-bdee-1cf2-3b09-b294b5cd7b49@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,
could someone help me build a connectionstring to use in Access VBA to
get a SSL Connection or is there an HowTo?

Client is Access 2013 with psqlODBC 9.5.400.
Server PostgreSQL 9.5 on UBUNTU 16.04.1 with the standard installation.
postgresql.conf has SSL=ON so I expect it to work? :}

pgAdmin connects just fine with "SSL = required".

This String works with VBA ADODB.Connection without SSL:
strCon = "DRIVER={PostgreSQL
UNICODE};DATABASE=db_test;SERVER=192.168.1.1;PORT=5432;UID=me;PWD=x;A1=7.4+;B1=65535;A7=50;B9=0;C6=1;A4=1;C5=1;C4=1;C8=1;B6=1;UniqueIndex=1;B7=1;AB=0x2"

BTW is this still OK? I used this for years.

When I add ";sslmode=require" connection.open fails with:
-2147467259 server does not support SSL, but SSL was required

In the parameter-list there is CA as abrevation for sslmode
There is no further information what values are needed.
Adding ";CA=1" connects to the server but how would I know if it is
encrypted?

Additional question: How can I activate SSL Compression?

Regards
Andreas

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Andreas 2016-11-09 18:59:41 md5 password encryption?
Previous Message Vincenzo Turturro 2016-11-09 11:06:26 Re: Problem in using PostgreSQL ODBC driver with VBA