Thread: Re: [ODBC] pgAdmin II /odbc connect errors
-----Original Message-----
From: hero [mailto:hero@ms3.url.com.tw]
Sent: 14 September 2001 05:27
To: pgsql-odbc@postgresql.org
Subject: [ODBC] pgAdmin II /odbc connect errorsHello I am trying to install pgAdmin II (version 1.1 Build 28) on my win98.I use pgAdmin II connect remote postgresql of linux( version 7.1.2)I keep an error follow:2001-09-14 11:48:07 - Error
2001-09-14 11:48:07 - *******************************************************************
2001-09-14 11:48:07 - Error in pgAdmin II:frmConnect.cmdConnect_Click: -2147467259 - Could not connect to the server;
Could not connect to remote socket.
2001-09-14 11:48:07 - Windows Version: Windows 98 v4.10 build 2222 A
2001-09-14 11:48:07 - pgSchema Version: 1.0.162
2001-09-14 11:48:07 - MDAC Version: 2.6
2001-09-14 11:48:07 - cnPostgreSQL.State = adStateClosedMy odbc driver version:07_01_0006
[CC'd to pgadmin-support@postgresql.org]
This error comes from the ODBC driver. You need to check the following:
1) You have specified the correct host & port in the logon dialogue.
2) Your network is working (e.g. ping servername gets responses).
3) PostgreSQL must be running on the server and allowing TCP/IP connections (start the postmaster with -i option).
4) The pg_hba.conf file on the server must allow your client/username to connect to (at least) the template1 database.
hth, regards, Dave.