Thank's Helen,..

I did that, for many times. But not work's. I installed Firebird as default.
And I never change my firebird.conf before.

I tried to restart my machine, and error was still appear. I don't know
what's wrong here.

I login to my computer as ADMINISTRATOR, then I login to my FBserver (from
DDL client (IB EXPERT personal edition)) as SYSDBA. Or maybe I need to
configure others parameter at my Firebird.conf? the only one parameter in my
firebird.conf that was configured by myself is ExternalFileAccess = d:\data
so, what next? Please give me solution?

Thank's before



Agung





_____

From: Helen Borrie [mailto:helebor@...]
Sent: 11 Desember 2004 17:52
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] external table problem



* 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



.



[Non-text portions of this message have been removed]