Subject Re: [ib-support] Database corrupted
Author Paul Reeves
On Mon, 13 May 2002 11:44:21 -0300, Roberto de Amorim wrote:
>Hi all,
>I have been being sad with the Interbase's results... My application
>is used in 642 companies and almost everyday I receive a bad notice
>that the database in corrupted in one of them...


>I'm using Delphi 5, IB6, Asta 4.6 with IBXServer and it occurs
>usually in lacks of energy.

If you mean after there has been a power failure then the solution is simple. Write a little batch file that will call gfix to set forced writes to ON. Get all of your customers to run it. Your customers will no longer experience this problem.

InterBase 6 was shipped to create databases with forced writes OFF by default. This almost always leads to corruption under Win32 if the power fails. Firebird 1.0 creates new databases with Forced Writes ON by default under windows. However, although I would recommend that you upgrade to Firebird the upgrade will not change the forced writes setting of an existing database.

Paul Reeves
Supporting users of Firebird and InterBase