Re: connect error

From: "Tibor Laszlo" <ltibor(at)mail(dot)tiszanet(dot)hu>
To: "ODBC" <pgsql-odbc(at)PostgreSQL(dot)org>
Subject: Re: connect error
Date: 2001-12-04 10:35:07
Message-ID: NFBBJBAOELFIEKMDJAFFIEINCCAA.ltibor@mail.tiszanet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> ODBC driver version:
> PostgreSQL ODBC Driver 07.01.0006
>
> PostgreSQL database version :
> PostgreSQL 7.0.2
>
> error messages:
> Already connected

I apologize for the late respond but only today could I try this.

We get the same "Already connected" error message with C++Builder +
ODBCExpress after every second connection request. We don't know the reason
and the source of the message, so we made a workaround about a year ago. The
error is still coming. Now we use PostgreSQL 7.1.3 and ODBC Driver
07.01.0008/older (under Win98hun/2000hun).

The error appears with the main application connection, which the user can
turn on and off any time. The first time the login seemed correct, then I
logged off and tried to connect again (no matter with what correct user).
Here is the log extract:

conn = 33657616, PGAPI_Connect(DSN='tir', UID='***', PWD='***')
Global Options: Version='07.01.0008', fetch=100, socket=4096,
unknown_sizes=0, max_varchar_size=254, max_longvarchar_size=8190
disable_optimizer=1, ksqo=1, unique_index=0,
use_declarefetch=0
text_as_longvarchar=1, unknowns_as_longvarchar=0,
bools_as_char=0
extra_systable_prefixes='dd_;', conn_settings=''
conn_encoding='OTHER'
CONN ERROR: func=PGAPI_Connect, desc='Error on CC_connect', errnum=202,
errmsg='Already connected.'
------------------------------------------------------------
henv=34541424, conn=33657616, status=1, num_stmts=16
sock=0, stmts=34813072, lobj_type=-999
---------------- Socket Info -------------------------------

The next time the connection will be accepted with this OID and PWD or with
any other correct user. Then logoff and connection error again - and so on.
I use the same hdbc all the time.

Note the error comes only with ODBCExpress. We used to use BDE components
without (seeing) this error. Hisoshi, I hope this helps.

Tibor Laszlo
ltibor(at)mail(dot)tiszanet(dot)hu

In response to

  • connect error at 2001-11-29 08:39:12 from 綜合システム 支援G 大坪慶子

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2001-12-04 23:37:35 Re: connect error
Previous Message Keith Gray 2001-12-04 05:16:36 Re: creating a primary key