Subject Re: External Tables
Author Bert_Herngreen
--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:
>
> Bert,
>
> At 05:18 PM 2/11/2006, you wrote:
>
> >A test with the 2.5 GB file (recreated) on the NTFS partition shows
> >the same error:
> >
> >Statement failed, SQLCODE = -902
> >I/O error for file "C:\MONTHLY_BILLED_CALLS.TXT"
> >-Error while trying to open file
> >-Het apparaat herkent de opdracht niet.
> >
> >When I produce 2 files of 1.25 GB there are no errors again.
>
> Originally you said:
>
> > I use Firebird 2.0 RC5 (on NTFS) with the fixed length file on
fat32.
>
> What kind of partition is the database file on?
>
> ./heLen
>

That was/is true, the database file (fdb) is on NTFS. During the
first message in the newsgroup/test the External Files were on Fat32,
but with the last test I tried with the NTFS partition. However there
is a limit of 2 GB on all platforms and filesystems according to
Dmitry Yemanov's message.

Thank you for your support, I'll split up the files in Future.

Bert