How to configure Microsoft Access to connect to a PostgreSQL database?

From: KARIN SUSANNE HILBERT <ioh1(at)psu(dot)edu>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to configure Microsoft Access to connect to a PostgreSQL database?
Date: 2017-03-07 23:46:23
Message-ID: 1222758157.7589913.1488930383216.JavaMail.zimbra@psu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Neha Khatri 2017-03-07 23:58:11 Re: [NOVICE] opr_charset rule in gram.y
Previous Message Neha Khatri 2017-03-07 23:22:56 Re: [NOVICE] opr_charset rule in gram.y