Re: [firebird-support] Re: Which connection causes object in use - is there a way to find that out?

2016-10-26 Thread rgilland1...@gmail.com [firebird-support]
This is something I asked several years ago, with no answer that I was happy with or could use. At least the exception should contain the connection IDs, holding the procedure in use.

Re: [firebird-support] Unable to upgrade database to firebird 3.0

2016-10-26 Thread 'Mark Rotteveel' m...@lawinegevaar.nl [firebird-support]
Firebird 3 does not support old ODS versions. You will need to backup with Firebird 2.5 and then restore under Firebird 3. Mark - Bericht beantwoorden - Van: "'Joje' j...@codework-solutions.com [firebird-support]" Aan:

RE: [firebird-support] Unable to upgrade database to firebird 3.0

2016-10-26 Thread 'Joje' j...@codework-solutions.com [firebird-support]
Thanks it worked now I am able to connect to database. And I have upgraded to FB 3.0.1 !! Another thing did anyone faced ODS version issue. Like I got this issue of database ODS ver. 11.5 is lower than Current ODS ver 12.0. If so then how could we solve this problem ? Thank you.

AW: [firebird-support] Unable to upgrade database to firebird 3.0

2016-10-26 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support]
I forgot.. may you have also to update to version 3.0.1! Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Gesendet: Mittwoch, 26. Oktober 2016 15:33 An: firebird-support@yahoogroups.com Betreff: [firebird-support] Unable to upgrade database to firebird 3.0

AW: [firebird-support] Unable to upgrade database to firebird 3.0

2016-10-26 Thread 'Gregor Kobler' g...@gksoft.ch [firebird-support]
Hello Joje I hade the same problem You have to choose the client library from a other directory than < c:\program files\firebird\firebird_3_0 > May you choose You have to set this in the Host Registration Info under the register

Re: [firebird-support] Unable to upgrade database to firebird 3.0

2016-10-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.10.2016 15:33, 'Joje' j...@codework-solutions.com [firebird-support] wrote: > Could someone suggest another method to connect to database. Use TCP/IP connection string or exact XNET prefix. -- WBR, SD.

[firebird-support] Unable to upgrade database to firebird 3.0

2016-10-26 Thread 'Joje' j...@codework-solutions.com [firebird-support]
Hello All, Recently I upgraded my Firebird from 2.5 to 3.0 and I am using 'EMS SQL Manager Interbase/Firebird' to connect and work with database. Now whenever I connect existing database or register a new database I get following error Unsuccessful execution caused by system error

[firebird-support] Re: Optimizer request

2016-10-26 Thread Virgo Pärna virgo.pa...@mail.ee [firebird-support]
On Wed, 19 Oct 2016 09:34:32 +0200 (CEST), ehmmm.fireb...@seznam.cz [firebird-support] wrote: > > update orders o > set o.something = 'something other' > where o.delivery_date is null >   and o.partid in (select p.partid from partners p where p.country='Spain')

Re: [firebird-support] How to estimate free space inside database file

2016-10-26 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
26.10.2016 11:50, Bryan Cole bryan.c...@teraview.com [firebird-support] wrote: > Sadly, I'm unable to use the ibsurgeon tools. My database is running on a > headless linux > server. I need to estimate the database free space from another > server-application. Use other approach: estimate

RE: [firebird-support] How to estimate free space inside database file

2016-10-26 Thread Bryan Cole bryan.c...@teraview.com [firebird-support]
Thanks for this info. Sadly, I'm unable to use the ibsurgeon tools. My database is running on a headless linux server. I need to estimate the database free space from another server-application. Thus, a linux commandline tool or library would work for me. Better would be a SQL query I can use