From: | ml(at)jpn(dot)tuv(dot)com |
---|---|
To: | pgsql-interfaces(at)postgreSQL(dot)org |
Subject: | [ODBC] Windows NT, ODBC 3.x, problem to connect |
Date: | 1998-06-23 13:27:50 |
Message-ID: | 4925662C.0042A8C3.00@gateway-notes.jpn.tuv.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Maxim V. Kashin | 1998-06-23 14:55:46 | HELP |
Previous Message | Shin-Young Choi | 1998-06-23 10:42:29 | ODBC |