Hello 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 = adStateClosed
My odbc driver version:07_01_0006
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.