Thread: [NOVICE] How to configure Microsoft Access to connect to aPostgreSQL database?
[NOVICE] How to configure Microsoft Access to connect to aPostgreSQL database?
From
KARIN SUSANNE HILBERT
Date:
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.
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
Re: [NOVICE] How to configure Microsoft Access to connect to aPostgreSQL database?
From
Moreno Andreo
Date:
Hi Karin,
sorry for late reply.
Il 08/03/2017 00:46, KARIN SUSANNE HILBERT ha scritto:
sorry for late reply.
Il 08/03/2017 00:46, KARIN SUSANNE HILBERT ha scritto:
Unfortunately, no.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?
This appears to be a pg_hba configuration issue... could you please send its content?
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