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!
