Subject Re: [firebird-support] Keep alive connection (Delpih, IBX)
Author Martijn Tonies
Hi,

> When a user leave the machine for a while (not closeing the program) then
> after returning he cannot continue working. He gets "error reading from
> the connection" error. I know the cause. It's TCP timeout. To avoid I have
> to run dummy select to keep alive.
>
> I use IBX to connect FB.
>
> My question is : Do I need to run dummy select per active connection or
> per active transaction?

As far as I know: per connection.

With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!