I don't know for sure but you may want to look at the ForcedWrites status of
your database to see if that accounts for the difference.

Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of ifitsx
Sent: 06 February 2012 12:24 PM
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Migration to IBO 4.9/DXE2 changes db file behavior







--- In IBObjects@yahoogroups.com, "IBO Support List" <supportlist@...>
wrote:

>
> You should NOT have that file being backed up directly. You should only
> archive a file created as a result of a gbak operation to create a backup
> file.
>
> Jason

Jason, I appreciate your concern. However, I believe I have always clearly
understood these issues as long as the info in The Firebird Book is
accurate: my Firebird database files have never been backed up while they
are open unless with gbak.

As I read Chapter 38, p.813, of The Firebird Book, 1st ed. which states that
"Do not rely on backups of your Firebird databases made by ... filesystem
copy utilities, or compression utilities... <i>unless the database is
completely shut down.<i>

The phrase "unless the database is completely shut down" means to me that
making a backup copy or compressed archive of the database when it is
shutdown will result in a reliable backup.

I have used the Firebird backups made by AJC Active Backup and they have
always resulted in a reliable return of my data.

Now, my original question is still open: is there something about the
combination of "IBO4_9_14_b36i/DXE2/sp3/Win7 x64" which is changing the
database's date/time upon opening that can be altered to stop this and
return it to its original behavior where the database's date/time is not
changed until the database is closed.

Barry

> -----Original Message-----
> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On

Behalf

> Of ifitsx
> Sent: 06 February 2012 09:30 AM
> To: IBObjects@yahoogroups.com
> Subject: [IBO] Migration to IBO 4.9/DXE2 changes db file behavior
>
> New system: IBO4_9_14_b36i/DXE2/sp3/Win7 x64
> Old system: IBO4_2Hd/D7/Win2k/sp4
>
> Using just IBODatabase and IBOQuery.
>
> I have discovered that an app which uses IBObjects/Firebird and has been
> migrated to DXE2 changes its file date/time as soon as it is opened,
> whereas, my other app, still under IBO4_2Hd/D7, when opened still has its
> file date/time listed for when it was closed the previous evening. (Both

are

> now running on Win7 x64.)
>
> This change in behavior is interfering with AJC Active Backup, my file
> archiving/backup app, which has a color coded icon in the tray: When it is
> open and active but not archiving anything, it is green; when it is
> archiving something it turns yellow; when it is open, but turned off the
> icon is red.
>
> So, with this change in behavior, I don't have the opportunity to actively
> monitor that my other files are being archived, because as soon as I open
> the app migrated to IBO4_9x/DXE2, the AJC icon turns yellow and stays that
> way all day until I close the app.
>
> If there is something IBO related that I can do to change this behavior -
> stop the database file's date/time from being changed when the db is

opened

> - I'd be grateful to know what I might do.
>
> Barry
>

------------------------------------

___________________________________________________________________________
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 !
Yahoo! Groups Links