Subject Re: External Files failing in Classic Firebird
Author Adam
--- In firebird-support@yahoogroups.com, "robertgilland"
<robert_gilland@...> wrote:
>
> I have Firebird 1.53 Classic funning with
>
> This line in Firebird.conf
> ExternalFileAccess = Full
>
> After running the below statement I get this error.
> What is it?
> How can I stop it?
>
> Regards,
>
> Robert.
>
> ISC ERROR CODE:335544344
>
> ISC ERROR MESSAGE:
> I/O error for file "C:\EXT_COMM.ASC"
> Error while trying to open file
> The operation completed successfully.
>
> Statement: CREATE TABLE EXT_COMMODITIES
> EXTERNAL FILE 'C:\EXT_COMM.ASC'
> ( STOREID CHAR(10) CHARACTER SET ASCII
> , DEPTCODE CHAR(10) CHARACTER SET ASCII
> , COMMODITYCODE CHAR(10) CHARACTER SET ASCII
> , COMMODITYNAME CHAR(50) CHARACTER SET ASCII
> , ISSENT CHAR(1) CHARACTER SET ASCII
> ,NEWLINECHAR CHAR(2) CHARACTER SET ASCII
> )
>

My guess is some other process has this file locked. It works fine
for me. Try and rename the file in explorer to test it.

Also check the file system permissions (by default it should be
SYSTEM which should have enough access). Classic will read the
changes to the firebird.conf when you connect. Superserver needs the
service to be restarted.

Adam