Subject Re: External Tables
Author Bert_Herngreen
--- In, Helen Borrie <helebor@...>
> 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
> 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.