Can't connect by ODBC

From: Andreas Schlegel <schlegel(at)software(dot)b(dot)uunet(dot)de>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Can't connect by ODBC
Date: 2002-04-13 14:23:01
Message-ID: 3CB83F45.867F1673@software.b.uunet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,

I get the following error message to connect on Postgres 7.0 with ODBC:
"Could not connect to server; Could not connect to remote socket.
(#101)"

I have no problems to work on psql with telnet from a win client.

My configuration:

pg_hba.conf:
host all 192.168.90.0 255.255.255.0 trust

/etc/init.d/postgresql:
OPTIONS=${POSTGRES_OPTIONS:-"-i"}

Server: Postgres 7.0 and Suse 7.2
Client: ODBC 7.01.00.10 and W2K

Has anybody any ideas on what might have changed?

Greetings,
Andreas

My log:
Global Options: Version='07.01.0010', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=1,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
CONN ERROR: func=PGAPI_DriverConnect, desc='Error from CC_Connect',
errnum=101, errmsg='Could not connect to the server'
------------------------------------------------------------
henv=153421936, conn=153383568, status=0, num_stmts=16
sock=153421888, stmts=153421808, lobj_type=-999
---------------- Socket Info -------------------------------
socket=-1, reverse=0, errornumber=4, errormsg='Could not
connect to remote socket.'
buffer_in=153394488, buffer_out=153398592
buffer_filled_in=0, buffer_filled_out=0, buffer_read_in=0

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Johann Zuschlag 2002-04-13 14:59:48 Re: Can't connect by ODBC
Previous Message Thanner Rodrigo Almeida 2002-04-13 01:18:25 ERROR: