Re: connect error

> 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@mail.tiszanet.hu