Il 08/03/2017 00:46, KARIN SUSANNE HILBERT ha scritto:
I have a new PostgreSQL database that the customer wants to access via Microsoft Access. I did some searching for how to do this & found some nice instructions at https://astuntech.atlassian.net/wiki/display/ISHAREHELP/Connect+Microsoft+Access+to+PostgreSQL but it specifies setting the SSL Mode to disable when configuring the ODBC connection. We will need to use SSL. Does anyone have any experience with configuring this?
Unfortunately, no.
We're getting these errors when he tries to connect: 2017-03-01 15:09:57 EST [5832]: [1-1] db=[unknown],user=[unknown] LOG: connection received: host=name.xxx.xxx.xxx port=50645 2017-03-01 15:09:57 EST [5832]: [2-1] db=ecomctrl,user=ecom_db FATAL: pg_hba.conf rejects connection for host "xxx.xxx.xxx.xxx", user "user", database "dbname", SSL off
This appears to be a pg_hba configuration issue... could you please send its content?
The customer just wants to give up & put the database on SQL Server, but I'd like to try & get it working with PostgreSQL if we can. Any help would be appreciated.