Re: [ODBC] pgAdmin II /odbc connect errors

-----Original Message-----
From: hero [mailto:hero(at)ms3(dot)url(dot)com(dot)tw]
Sent: 14 September 2001 05:27
To: pgsql-odbc(at)postgresql(dot)org
Subject: [ODBC] pgAdmin II /odbc connect errors

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

[CC'd to pgadmin-support(at)postgresql(dot)org
<mailto:pgadmin-support(at)postgresql(dot)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.