Are you sure you left the #s at the beginning of the line?
Becuase that will do nothing at all, these settings will remain defaults
(for external tables that means None)

SanTa

----- Original Message -----
From: "korkless" <korkless@...>
To: <firebird-support@yahoogroups.com>
Sent: Tuesday, November 17, 2009 9:57 AM
Subject: [firebird-support] external table don't work


> hi all, i'm using firebird 2.1 with windows (32).
> i'm using the super-server version.
>
> i have set in firebird.conf
> #ExternalFileAccess = Full
> #DatabaseAccess = Full
> (i use Full only to make it works without problem, then i will reduce
> them)
>
> i'm trying to create an external table in the same dir of my db
> (the directory is in c:\ partition in the machine where the service is
> running).
>
> i'm using this sql (i try both in isql and sql manager 2008 for firebird)
> CREATE TABLE ext1 EXTERNAL 'c:\MY DB DIR\myfile.txt'
> (
> field1 char(20),
> field2 smallint
> );
>
> this statement is executed without problem (but no file is created).
> if i make same action on that table i got an exception
> Access to external file 'c:\MY DB DIR\myfile.txt' is denied by server
> administrator.
>
> Note: after that i changed the firebird.config i had rebooted the machine
>
> Note2: the windows permission on my db dir are the defaults and all work
> perfect with db file so i think that the permission error is about
> firebird permission
>
> i don't know where i wrong, has samebody an idea?
>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org 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
>
>
>