Re: [firebird-support] dropping the connection

2017-02-24 Thread Nick Upson n...@telensa.com [firebird-support]
I remember killing connection via delete from mon$statements with firebird 2.0 or 2.1. Could the fact that it doesn't work for me now be down to upgrading the client install to 2.5? On 22 February 2017 at 09:44, Mark Rotteveel m...@lawinegevaar.nl [firebird-support]

Re: [firebird-support] dropping the connection

2017-02-22 Thread hv...@users.sourceforge.net [firebird-support]
---In firebird-support@yahoogroups.com, wrote : > Killing connections by deleting from MON$STATEMENTS requires Firebird > 2.5 and an ODS 11.2 database (so you will also need to backup and > restore the database when migrating to Firebird 2.5!). MON$ATTACHMENTS ;) Regards, Vlad

Re: [firebird-support] dropping the connection

2017-02-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2017-02-21 17:32, Nick Upson n...@telensa.com [firebird-support] wrote: > Hi > > The problem I'm trying to solve is users leaving inactive db_workbench > sessions attached to a database while other work is going on by other > processes, causing a large OIT gap and the consequent problems. The

[firebird-support] dropping the connection

2017-02-21 Thread Nick Upson n...@telensa.com [firebird-support]
Hi The problem I'm trying to solve is users leaving inactive db_workbench sessions attached to a database while other work is going on by other processes, causing a large OIT gap and the consequent problems. The solution needs to be automatic and unattended. db_workbench doesn't have a timeout