At 01:24 PM 11/12/2004 +0700, you wrote:

>Hi,..
>I learn about Firebird external file. I never use external file before, then
>I try to declare my query like this :
>
> CREATE TABLE EXT_TBL EXTERNAL FILE 'exfile.txt'
>
>(FNAME CHAR(10),
>
>LNAME CHAR(20),
>
>NEWLINE CHAR(1));
>
>But I got error :
>
>"Cannot commit transaction:
>Unsuccessful execution caused by a system error that precludes
>successful execution of subsequent statements.
>Access to external file "file.txt" is denied by server administrator."
>
>I try to create exfile.txt, and I locate this file to some directory, and I
>try to redeclare my query with file path..
>
>But I still get error. Can somebody help me??
>
>Winxp, Firebird 1.5.1 superserver.

The examples in the Borl docs are very slack. You shouldn't be trying to
create an external file in some default directory.

Roll back this transaction and begin again.

1. Create a directory where you are going to store external files. Let's
suppose it is d:\files
and make sure that the owner of the firebird process has full privileges to
it (this will be OK if you did the default install)

2. Check the firebird.conf file and find the parameter
ExternalFileAccess. If I recall correctly, its default looks like this:
# ExternalFileAccess = NONE

Remove the '#' and change this to:

ExternalFileAccess = d:\files

3. Shut down and restart the server.

4. Log in and attach to your DDL client.

5. Now, do the definition again; but this time supply the fully-qualified
path to the file (the file need not exist).

CREATE TABLE EXT_TBL
EXTERNAL FILE 'd:\files\exfile.txt'
(
FNAME CHAR(10),
LNAME CHAR(20),
NEWLINE CHAR(2));

Note that on Windows the carriage return is 2 bytes, not one.

./heLen