Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group