At 01:05 PM 26/04/2006, you 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?

Make sure another application doesn't already have it opened, e.g.
Notepad, Excel or whatever. If the file exists, firebird has to be
able to open it for exclusive read/write; if it doesn't exist,
firebird has to be able to create it.

./heLen

>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
>)
>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>