> 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

>
> Jason Wharton
> www.ibobjects.com
>
>
> > -----Original Message-----
> > From: Josh Higgs [mailto:Josh@...]
> > Sent: Wednesday, December 01, 2004 12:04 AM
> > To: IBObjects@yahoogroups.com
> > Subject: [IBO] Phantom connections?
> >
> >
> >
> > connection/queries/disconnection process, IB_Objects is
> > creating not one,
> > but two connections to the database, and releases only one on
> > disconnection.