Hi

All clients use to programs.

1 using TIBQuery.
1 using BDE.

In TIBQuery I always do a

try
if not tr.active
tr.Start transaction

Do whatever.. .. ..

tr.Commit
except
tr.rollback;
end;

And when they close a window, I do a Commit on all active
transactions.

The BDE I'm not so sure.

So now I will see if I can locate the problem.


Thanks so far.

Michael
--- In ib-support@yahoogroups.com, Svein Erling Tysvaer
<svein.erling.tysvaer@k...> wrote:

> At 12:03 09.01.2003 +0000, you wrote:
> >Well.
> >
> >I.e. today the gab is after 4 hours somewhere around 2000.
> >
> >My software runs on a Terminal Server.
> >The clients connects to this server, and works there.
> >My customer has just moved to a new location.
> >
> >Therefor they have gotten a new router etc.
> >After this the clients "falls off" every once in a while.
> >
> >When they fall off, whatever programs they had opend will be
> >terminated.
> >
> >Could this termination couse the gab to grow ?
>
> No, it shouldn't. The server should discover that the connections

are no

> longer valid and rollback the open transaction(s). You are looking

for

> something that stays open for a long time, either due to you

opening

> something explicitly, your connection tool doing it implicitly

without your

> knowledge (are you using IBO, IBX, BDE or what?) or use of a

another tool

> (e.g. IB_SQL).
>
> HTH,
>
> Set
>
> - I support Firebird, I am a FirebirdSQL Foundation member.
> - Join today at http://www.FirebirdSQL.org/Foundation