Skip site navigation (1) Skip section navigation (2)

Re: [ODBC] pgAdmin II /odbc connect errors

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'hero'" <hero(at)ms3(dot)url(dot)com(dot)tw>, pgsql-odbc(at)postgresql(dot)org
Cc: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>
Subject: Re: [ODBC] pgAdmin II /odbc connect errors
Date: 2001-09-14 14:47:33
Message-ID: 8568FC767B4AD311AC33006097BCD3D61A2E45@woody.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-supportpgsql-odbc
 

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

pgsql-odbc by date

Next:From: Mike RenfroDate: 2001-09-14 14:58:31
Subject: Re: secure ODBC connection
Previous:From: Dave PageDate: 2001-09-14 07:25:51
Subject: Re: Installer question

pgadmin-support by date

Next:From: Mike AraceDate: 2001-09-17 02:19:44
Subject: bug report
Previous:From: Jean-Michel POUREDate: 2001-09-01 08:55:02
Subject: Test

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group