I have an application that is installed without issue on about 20
different client sites. The application does a nightly data dump into a
Firebird SQL database and works fine.

One client, however, has been reporting that about every 10 or so days,
his stops working completely. The fix is to stop and restart Firebird
from the Control Panel applet.

Today I got a call from the client that the data didn't load again, and
had one of our developers write a small diagnostic application that
would allow me to test a connection either directly to the Firebird
database (using FBCLIENT.DLL) or through an ODBC Data Source (using the
free Firebird ODBC Drivers). When I attempted this, after the
application had failed to do its data load, both connection attempts
gave back the following error:

"Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements. Operating system
directive CreateFile failed. The requested operation cannot be
performed on a file with a user-mapped section open"

When I force restart Firebird server, and try the same diagnostic
connection again, it works perfectly. So something is causing this
problem directly with Firebird and I'm not sure where to look for the
solution.

Does anyone have any idea what this error is referring to, and what this
client may have done with their server setup that is causing this error?

Thanks in advance for any suggestions.

Myles
--
=======================
Myles Wakeham
Director of Engineering
Tech Solutions USA, Inc.
Scottsdale, Arizona USA
http://www.techsolusa.com
Phone +1-480-451-7440