Michael,

> > Do I need to run dummy select per active connection or per active
> > transaction?
>
> Per connection, because one connection is tied to one socket, whereas each
> connection *may in theory* host multiple transactions.

There is no "in theory" it is a fact.

We have a Delphi application which has multiple transactions via a single connection.

Your issues may be due to the IBX component set, our app uses IBO.


Sean