Subject RE: [firebird-support] Questions about FB file size limits
Author Johan van Zyl
It is very important to me - what is the limitation on Win 2000 Pro/Win 2000
Server/Suse/Readhat etc?
I must decide VERY soon what we are going to do for a client of mine.
-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: 30 August 2004 22:39
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

Yahoo! Groups Links

a.. To visit your group on the web, go to:

b.. To unsubscribe from this group, send an email to:

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
Version: 6.0.745 / Virus Database: 497 - Release Date: 2004/08/27

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