<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">Hi Karin,<br>
sorry for late reply.<br>
<br>
Il 08/03/2017 00:46, KARIN SUSANNE HILBERT ha scritto:<br>
</div>
<blockquote
cite="mid:1222758157(dot)7589913(dot)1488930383216(dot)JavaMail(dot)zimbra(at)psu(dot)edu"
type="cite">
<div style="font-family: arial, helvetica, sans-serif; font-size:
14pt; color: #000000">
<div>I have a new PostgreSQL database that the customer wants to
access via Microsoft Access.<br>
I did some searching for how to do this & found some nice
instructions at
<a class="moz-txt-link-freetext" href="https://astuntech.atlassian.net/wiki/display/ISHAREHELP/Connect+Microsoft+Access+to+PostgreSQL">https://astuntech.atlassian.net/wiki/display/ISHAREHELP/Connect+Microsoft+Access+to+PostgreSQL</a><br>
but it specifies setting the SSL Mode to disable when
configuring the ODBC connection.<br>
We will need to use SSL. Does anyone have any experience with
configuring this?<br>
</div>
</div>
</blockquote>
Unfortunately, no.<br>
<blockquote
cite="mid:1222758157(dot)7589913(dot)1488930383216(dot)JavaMail(dot)zimbra(at)psu(dot)edu"
type="cite">
<div style="font-family: arial, helvetica, sans-serif; font-size:
14pt; color: #000000">
<div><br>
We're getting these errors when he tries to connect:<br>
2017-03-01 15:09:57 EST [5832]: [1-1]
db=[unknown],user=[unknown] LOG: connection received:
host=name.xxx.xxx.xxx port=50645<br>
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<br>
</div>
</div>
</blockquote>
This appears to be a pg_hba configuration issue... could you please
send its content?<br>
<blockquote
cite="mid:1222758157(dot)7589913(dot)1488930383216(dot)JavaMail(dot)zimbra(at)psu(dot)edu"
type="cite">
<div style="font-family: arial, helvetica, sans-serif; font-size:
14pt; color: #000000">
<div><br>
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.<br>
Any help would be appreciated.</div>
<div><br data-mce-bogus="1">
</div>
<div>Thanks, </div>
<div>Karin Hilbert</div>
</div>
</blockquote>
<p><br>
</p>
</body>
</html>