|Subject||Re: [IBO] Phantom connections?|
> If you would, please try and decipher exactly what the contents of the tebsource
> is when that call is made so we can rule out IBO or the server as the
> of the problem. If the teb is the same then the problem is under thehood.
> 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,
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...
> Jason Wharton
> > -----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.