Subject Re: [firebird-support] Crash corrupted database file
Author Helen Borrie
At 03:57 PM 22/10/2009, you wrote:
>I am using Firebird embedded in a windowsXP application and using the .net driver. We had an unexpected crash (bluescreen) of the computer and now I get an exception opening the database file. The file opens fine in FlameRobin and all the data in the tables look fine.
>Does anyone have any idea about how this could happen and what is wrong? This is the first time I have seen a file get corrupted in about 3 years of development on this app.
>Relevant section from application log file:
>2009-10-22 15:23:59,622 [2408] ERROR- FirebirdSql.Data.FirebirdClient.FbException: I/O error for file ReadFile "E:\dbfile.gdb"

If FlameRobin can open it without exceptions, what makes you think it's corrupted?

windowsXP + "E:\dbfile.gdb" - the well-known, documented-to-death case is an obvious cause. Try changing the file suffix to ".fdb". And don't try to start your app if FlameRobin or another instance of your app is already connected to the database: that will cause an i/o error too.