Subject Re: [firebird-support] Questions about FB file size limits
Author Daniel Rail

At August 30, 2004, 15:45, Ivan Prenosil wrote:

>> Statement failed, SQLCODE = -902
>> I/O error for file "C:\DB1\Data.txt":
>> -Error while trying to open file
>> -The device does not recognize the command.

> I can confirm that I get the same error message
> when reading external file larger that 2 GB !

> (Firebird 1.5.0, WinXP, NTFS)

Then it's not an OS limitation, but a FB limitation. And, an error in
Helen's book, since she mentioned the limitation for external file
size on NTFS is 4GB. But, I'll not hold her accountable, since it
depends where she got the information. Although, I think the
limitation should be dealt with.

Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (