| From: | Steven Adams <stevenadams(at)spiralxllc(dot)com> |
|---|---|
| To: | "pgsql-odbc(at)lists(dot)postgresql(dot)org" <pgsql-odbc(at)lists(dot)postgresql(dot)org> |
| Subject: | ODBC configuration problem |
| Date: | 2024-11-18 22:27:42 |
| Message-ID: | CYYPR11MB8306FC280BF8B21A209F9B55DE272@CYYPR11MB8306.namprd11.prod.outlook.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hello,
I'm trying to use MS Access with PostgreSQL and so want to configure an ODBC file for this. Testing it resulted in a connection timeout, so I looked at this to troubleshoot:
https://odbc.postgresql.org/faq.html#3.3
Adding a "tcpip=true" line to postgresql.conf and a line to permit a connection from the computer running Access to pg_hba.conf and then restarting PostgreSQL seemed to go without errors, but when I tried to run the psql command afterward, I got this error:
psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused
Is the server running on that host and accepting TCP/IP connections?
The psql command worked again after I undid these changes, so I'm trying to figure out how they caused this error. The line I added to pg_hba.conf was as follows.
host spiralxprime web_app 192.168.0.72 scram-sha-256
Any ideas as to why this is happening would be appreciated.
Regards,
Steven Adams
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Cramer | 2024-11-18 22:33:19 | Re: ODBC configuration problem |
| Previous Message | Dave Cramer | 2024-11-18 12:04:26 | Re: Unable to compile psqlodbc on unix - Missing configure script in psqlodbc beyond version 16 |