--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...> wrote:

>
> At 03:08 AM 10/01/2007, you wrote:
> >Hi, I meet this problem occasionally while I have no clue why this is
> >happening and it bothers me:
> >
> >Copy a new firebird DB and start the application to connect to the DB
> >in embedded embedded mode, sometimes it gives an error of "i/o error".
> >If I run the application again, it works fine since then. Seems
> >something was rectified after 1st failure.
> >
> >Not sure if it is caused by the way I created the database. Here are
> >the steps:
> >1. generate SQL from my development DB.
> >2. Run SQL to generate an empty database
> >3. Open the empty database in IBExpert in superserver mode, run
> >another sql to create some pre-defined records, the close the DB
> >connection.
> >
> >Unfortunately I cannot duplicate the problem. For one same database it
> >may have problem on one computer, but works fine on another one...
> >
> >Does anyone have a clue?
>
> It's probably due to not explicitly committing the script's work in
> IBExpert. Check how you have it configured with regard to committing
> transactions.
>
> ./heLen
>

After running the script, Script Executive asks "There are uncommited
statements. Commit them?". I always answer yes. Then I disconnect
from the database and copy the database file out.

I notice that after I disconnect from database, the fbserver.exe still
hold a handle to the database file. If I copy the db file with the
handle open, is that a problem?

-Sean