Subject RE: [firebird-support] Questions about FB file size limits
Author Mike Harbison

I am using Firebird 1.5.1 and I had used all previous versions of
Firebird. My databases are in excess of 11Gigs.

Works great.



From: Daniel Rail [mailto:daniel@...]
Sent: Monday, August 30, 2004 4:39 PM
Subject: Re: [firebird-support] Questions about FB file size limits


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. (

Yahoo! Groups Sponsor
click here



Yahoo! Groups Links

* To visit your group on the web, go to:

* To unsubscribe from this group, send an email to:

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <> .

[Non-text portions of this message have been removed]