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