I can't think of anything IB Objects related that would have the file remain
locked after it has done a disconnect and that was the only connection. I'm
wondering if there is some kind of a setting you can tell Firebird as to how
long it holds open a file even though there are no more active connections
to it.

Jason
www.ibobjects.com


-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Tuesday, May 20, 2014 4:00 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Does TIBODatabase hold .FDB files open?

We have a Delphi2010 app running that accesses two .FDB Firebird DB
files for related data. We do backup and restore from within the running
program, using a Component Ace Compression TZipForge component. Prior to
restore, we use the TIBODatabase.Disconnect to free the FDB files so the
TZipForge component's ExtractFiles can over-write them. However, if some
other user is still running the app on the DB, the restore will fail.
So, I've been tasked to test if the file is open PRIOR to the restore.
Yet, using Delphi's FileOpen or Rename methods, my attempts to open or
rename the file fail, even though I am the only user. I'm running them
after the disconnect; yet because I'm doing it within the app, is that
what's messing us up? Any guidance would help...

Thanks
Lane Campbell
NW Software


------------------------------------
Posted by: lcampbell <lcampbell@...>
------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
http://tracker.ibobjects.com - your portal to submit and monitor bug reports
http://community.ibobjects.com - your portal to purchase and upgradeYahoo
Groups Links