ODBC Driver - PostgreSQL - Connection Refused
Posted: Wed 20 May 2020 18:28
Unable to connect to remote PostgreSQL Server through ODBC Driver for PostgreSQL. Error Message below:
Cannot connect to server on host 'localhost':
Connection refused.
Socket Error Code: 111($6F))
However, we are able to successfully telnet and also ping the remote PostgreSQL Server without any issue.
Need help to understand why ODBC Connection (which works on TCP/IP) fails ,even though telnet and ping works. Strangely, when testing with an alternate ODBC Driver (IBM Data Direct , wire-protocol) works just fine.
Any other debug ideas would be appreciated.
Cannot connect to server on host 'localhost':
Connection refused.
Socket Error Code: 111($6F))
However, we are able to successfully telnet and also ping the remote PostgreSQL Server without any issue.
Need help to understand why ODBC Connection (which works on TCP/IP) fails ,even though telnet and ping works. Strangely, when testing with an alternate ODBC Driver (IBM Data Direct , wire-protocol) works just fine.
Any other debug ideas would be appreciated.