Josh,

Seems you understood perfectly what I was requesting. Thanks.

Indeed this does sound IB related. Is using Firebird an option? At least
with it you have a development community who will have open conversations
with you about this and you can bring resolution to this issue for everyone.

Thanks,
Jason Wharton
www.ibobjects.com

> -----Original Message-----
> From: Josh Higgs [mailto:Josh@...]
> Sent: Wednesday, December 01, 2004 5:34 PM
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Phantom connections?
>
>
>
> > If you would, please try and decipher exactly what the
> contents of the teb
> > is when that call is made so we can rule out IBO or the
> server as the
> source
> > of the problem. If the teb is the same then the problem is
> under the
> hood.
> > If the teb is different then it is something IBO is doing weird.
>
> I am not sure exactly what you are asking here, but I have
> compared the
> address as pointed to by PdbHandle in the call to
> isc_attach_database in
> TIB_Connection.API_Connect (triggered by
> IB_Connection.connected := true) to
> the address pointed to by pteb.db_ptr in the call to
> isc_start_multiple in
> TIB_Transaction.API_Start (triggered by IB_Cursor.open) and they are
> identical both when the second attachment is created and when
> it is not.
>
> The pteb.tpb_len is always reporting 4 regardless.
>
> The pteb.pb_ptr is a pchar with flags isc_tpb_version3, isc_tpb_write,
> isc_tpb_concurrency, isc_tpb_nowait
>
> This problem is linked to the database that I am using - ie.
> a backup and
> restore makes the problem go away. But the databases are not damaged.
>
> I have had similar problems in the past when running queries in other
> threads (this situation is a single threaded scenario) where
> IB decides to
> increment the attachment count to a ridiculous number ( over 100) even
> though there are only 2. It takes IB a few seconds to release each
> connection that it created. I never solved that one.
>
> It seems these problems could be IB not IBObjects related...
>
> Thanks
>
>
> Josh