Re: [firebird-support] Can't open firebird database files from a windows service.

2014-07-10 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 9-7-2014 20:57, vtre...@yahoo.com [firebird-support] wrote: We're in the process of changing an application that accesses a Firebird database file from a regular application to a windows service. For legacy reasons this uses the Firebird embedded DLL (fbclient) for version 1.5.6. The code

Re: [firebird-support] Database Forensics

2014-07-10 Thread Nick Upson n...@telensa.com [firebird-support]
you will need to copy the database to your hard disk, you can't operate with a database on a read-only media unless the database is prepared for this (seems unlikely)​ Nick Upson, Telensa Ltd, Operations Network Engineer direct +44 (0) 1799 533252, support +44 (0) 1799 399200 On 10 July 2014

Re: [firebird-support] no-wait vs wait transactions?

2014-07-10 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jul 9, 2014, at 3:09 PM, jonatan.laurit...@yahoo.dk [firebird-support] firebird-support@yahoogroups.com wrote: 1) Almost all of A-transactions end with success in my case, so almost always B-transactions will fail with deadlock message anyway. Therefore the wait mode has no

Re: [firebird-support] remove constraint

2014-07-10 Thread Wolfgang Kluge wkl...@kb-labuan.com [firebird-support]
Martijn thanks for your reply. On 07/07/14 15:14, 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support] wrote: Hello Wolfgang, ALTER TABLE tablename DROP CONSTRAINT INTEG_485 This works nicely. regards Wolfgang Kluge That should do the trick. Or find the