Subject RE: [IBO] Does TIBODatabase hold .FDB files open?
Author IBO Support List
Post date 2014-05-21T02:36:22Z
Hmmm... I'm not sure the UNC route is the way you would want to go.
I suggest you run this past the Firebird experts on the support list there.
 
No worries about wasting my time. I'm happy to help when I am able.
 
Jason

From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]
Sent: Tuesday, May 20, 2014 6:56 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Does TIBODatabase hold .FDB files open?

I'm embarrassed; solved my own problem, shoulda' waited to squawk. Turns out I was using the IP-format path (used to open the FDB files via the dataset; should have been using the Win7 UNC-form. Works fine. Thanks for the quich reply; sorry I wasted your time..

***************************************
On 5/20/2014 4:07 PM, 'IBO Support List' supportlist@... [IBObjects] wrote:
 

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

No virus found in this message.
Checked by AVG - www.avg.com
Version: 2014.0.4592 / Virus Database: 3950/7526 - Release Date: 05/20/14