Re: ODBC configuration problem
| От | Steven Adams |
|---|---|
| Тема | Re: ODBC configuration problem |
| Дата | |
| Msg-id | MW6PR11MB83105E8EAD67FA889E3B6ECEDE202@MW6PR11MB8310.namprd11.prod.outlook.com обсуждение исходный текст |
| Ответ на | ODBC configuration problem (Steven Adams <stevenadams@spiralxllc.com>) |
| Список | pgsql-odbc |
Okay, I posted about it on Github.
From: Steven Adams <stevenadams@spiralxllc.com>
Sent: Monday, November 18, 2024 4:27 PM
To: pgsql-odbc@lists.postgresql.org <pgsql-odbc@lists.postgresql.org>
Subject: ODBC configuration problem
Sent: Monday, November 18, 2024 4:27 PM
To: pgsql-odbc@lists.postgresql.org <pgsql-odbc@lists.postgresql.org>
Subject: ODBC configuration problem
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:
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
В списке pgsql-odbc по дате отправления: