Home > mailing lists

Thread: pgAdmin II /odbc connect errors

pgAdmin II /odbc connect errors

From

"hero"

Date:

14 September 2001, 13:35:42

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

Please help me .
Thank you,

Hero Lin

Re: pgAdmin II /odbc connect errors

From

Dave Page

Date:

14 September 2001, 23:10:37

-----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 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@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.