pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: ml@jpn.tuv.com
To: pgsql-interfaces@postgreSQL.org
Subject: [ODBC] Windows NT, ODBC 3.x, problem to connect
Date: Tue, 23 Jun 1998 22:27:50 +0900
Message-ID: <4925662C.0042A8C3.00@gateway-notes.jpn.tuv.com> (raw)


Hello folks,

after upgrading to PostgreSQL and PostODBC and Microsoft ODBC to the latest
versions I cannot connect to Postgres anymore.

Versions:
backend:  PostgreSQL 6.3.2
          Linux 2.0.30
          172.16.5.12
user:          PostgreSQL 6.30.0245
          WinNT WS 4.0 SP3
          ODBC 3.5
          172.16.4.233

error message:
When i try to create a query (MS-Query) i get the error message:
"Could not connect to the server;
 Could not connect to the remote socket."

When I connect via telnet to the server and use psql I can access the
requested database w/o problem.
The pg_hba.conf looks like this:
-----start-----
# first attempt
# allow all hosts from 172.16.4.x access to database test1
host    test1   172.16.4.0      255.255.255.0   trust

# second attempt
# allow workstation orion access to all databases
host    all     172.16.4.233    255.255.255.255 trust

# desperately seeking connection... in the third attempt
host    all     0.0.0.0         0.0.0.0         trust
host    all                                     trust
-----end-----

any ideas?

Thnx

Matthias





Message-ID: <4925662C.0042A8C3.00@gateway-notes.jpn.tuv.com>
Permalink:  ../4925662C.0042A8C3.00@gateway-notes.jpn.tuv.com/
Also on:    postgresql.org/message-id/4925662C.0042A8C3.00@gateway-notes.jpn.tuv.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: ml@jpn.tuv.com
  Subject: Re: [ODBC] Windows NT, ODBC 3.x, problem to connect
  In-Reply-To: <4925662C.0042A8C3.00@gateway-notes.jpn.tuv.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox