At 12:04 26/08/2008, you wrote:

>Hi all,
>
>I have set a database to read_only using gfix

******************************

>and i also set on the readonly file attribute under the OS (windows).

Why did you do that? Firebird database mode "read only" does NOT set the filesystem read-only attribute, nor does it intend that you should do that. A database that is locked inside a read-only file doesn't work - the engine has no way to write to the transaction inventory!

So - unset that attribute before connecting to the read-only database. If you are using a character set other than NONE then it's possible you might still encounter an exception, as there is a known bug relating to read-only databases and transliterating blobs.

./heLen