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?
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
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.
Thanks,
Karin Hilbert