From: ml@jpn.tuv.com
To: pgsql-interfaces@postgreSQL.org
Message-ID: <4925662C.0042A8C3.00@gateway-notes.jpn.tuv.com>
Date: Tue, 23 Jun 1998 22:27:50 +0900
Subject: [ODBC] Windows NT, ODBC 3.x, problem to connect
Mime-Version: 1.0
Content-type: text/plain; charset=us-ascii


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