Thanks to both Nando and Adam. I see now that the startup of the connection pool using the .Net provider locks the DB file in such a way that the OS explorer window does not receive the event to cause a redraw. The property window does however see the change. Once the pool is cleared the event is then passed to the explorer window.

Thanks Again

----- Original Message -----
From: Nando Dessena
To: firebird-support@yahoogroups.com
Sent: Wednesday, February 22, 2006 12:36 AM
Subject: Re: [firebird-support] Embedded Server Forced Writes Not Working


Hello,

W> Firebird 1.5.3
W> .Net Provider 1.7
W> Windos XP SP2

<SNIP>

W> Here is a quick test from an application that creates a database, a
W> table and adds 5000 rows. As soon as the database is created the
W> filesystem shows a new file of around 620K. After the insert the size is
W> still the same.

where are you looking at the file size? Windows Explorer is known in
that it doesn't update the file size until the file is closed. The
File Properties dialog is usually more up to date. In any case, don't
rely on the reported file size to judge whether the data has been
written to disk or not.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




SPONSORED LINKS Technical support Computer technical support Compaq computer technical support
Compaq technical support Hewlett packard technical support Microsoft technical support


------------------------------------------------------------------------------
YAHOO! GROUPS LINKS

a.. Visit your group "firebird-support" on the web.

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


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




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


No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.12/266 - Release Date: 2/21/2006

----------

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.12/266 - Release Date: 2/21/2006


[Non-text portions of this message have been removed]