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
