Re: SSL with Access VBA

On 11/09/2016 10:51 AM, Andreas wrote:
> 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?

What are your settings in pg_hba.conf for connections?

>
>
> Additional question: How can I activate SSL Compression?
>
>
> Regards
> Andreas
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com