Subject Re: [firebird-support] Re: Crash corrupted database file
Author Helen Borrie
At 12:06 PM 23/10/2009, you wrote:

>1.This application has been developed and used for several years now with no changes to the database, so I know it works. The "project" file for the application uses an embedded FB database. After a bluescreen, that particular project/database file is broken.
>2. I can open the file with Flame Robin no problem and it all looks good.

So the bluescreen is coincidental.

>3. When I try to access the file in my application, the .net driver for FireBird embedded throws an exception. "Error while trying to read from file ---> FirebirdSql.Data.Common.IscException"
>4. I can't get gfix to open the file, but then I can't get gfix to open a good file either so I'm not sure what is wrong there.
>Any ideas for things to check are much appreciated.

You seem to be confused about the setup of things with embedded. If you want to be able to use the command-line tools with the embedded server, set them up as embedded applications in their own fiesystem structure with their own copy of fbembed.dll (renamed to fbclient.dll) following the directions in the installation doc for setting up embedded applications.

If you have gfix then you must have got that from somewhere. - a full server kit? If you have that, then you must have the release notes and quick start guide in a ..\doc subdirectory.

Do you actually have a full server installed and running on that machine, in addition to this embedded app that you are having the problems with?

OTOH, if you extracted gfix.exe from a zip kit and just plonked it somewhere, not as part of an installation, it's not going to work if it's unable to find all the bits and pieces it needs access to. Gfix.exe is an application. It can work with embedded if you set it up properly in an embedded installation...details of this (absent all the dotNet fluff) are in the Installation and Migration doc.