Can't connect by ODBC

Поиск
Список
Период
Сортировка
От Andreas Schlegel
Тема Can't connect by ODBC
Дата
Msg-id 3CB83F45.867F1673@software.b.uunet.de
обсуждение исходный текст
Ответы Re: Can't connect by ODBC  ("Johann Zuschlag" <zuschlag2@online.de>)
Список 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

В списке pgsql-odbc по дате отправления:

Предыдущее
От: "Johann Zuschlag"
Дата:
Сообщение: Re: Error SQLFETCH - access violation - fixed
Следующее
От: "Johann Zuschlag"
Дата:
Сообщение: Re: Can't connect by ODBC