--- In firebird-support@yahoogroups.com, Helen Borrie <helebor@...>
wrote:

>
> At 08:13 AM 1/11/2006, you wrote:
> >Hello,
> >
> >Is there a maximum file size that can be used with Firebird (2.0)

as

> >an external table?
> >If I use multiple files of 100 MB, there are no problems, but when

I

> >use a single file of 2.5 GB and 'insert into [Internal table]

select

> >from [External Table]' an IO error happens.
> >
> >I use Firebird 2.0 RC5 (on NTFS) with the fixed length file on

fat32.

>
> It's a FAT32 limitation - 2Gb maximum addressable. Put the file on

a

> NTFS partition that was created by NT 5. Note that a NTFS

partition

> that was created by NT 4.0 has a 4 Gb addressable limit.
>
> ./heLen
>

I thought that Fat32 knows a filesize limit of 4 GB, but probably I'm
wrong.

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.