Subject Re: Creating an External table
Author robertgilland
I cannot find any documents that directly relate to firebird.conf
Where are they?

--- In firebird-support@yahoogroups.com, "Adam" <s3057043@...> wrote:
>
> --- In firebird-support@yahoogroups.com, "robertgilland"
> <robert_gilland@> wrote:
> >
> > What is wrong with this statement:
> >
> > CREATE TABLE "EXT_PLUSALES"
> > EXTERNAL FILE 'C:\PLUSALES.ASC'
> > ( STOREID VARCHAR(10) NOT NULL,
> > SALESDATE TIMESTAMP NOT NULL,
> > PLU VARCHAR(14) NOT NULL,
> > QUANTITYSOLD FLOAT,
> > COSTEXGST FLOAT,
> > COSTINCGST FLOAT,
> > SALESEXGST FLOAT,
> > SALESINCGST FLOAT,
> > PRIMARY KEY ( STOREID, SALESDATE, PLU ));
> >
> > I get this message:
> >
> > ISC ERROR CODE:335544831
> >
> > ISC ERROR MESSAGE:
> > Access to external file "C:\PLUSALES.ASC" is denied by server
> > administrator
>
> You need to change Firebird.conf (ExternalFileAccess), the conf file
> documents how this works. The service needs to restart to read in
the
> new values (possibly not for classic, but to be on the safe side).
>
> Second, the user Firebird is running as (normally LocalSystem) must
> have read/write file system access to this file.
>
> Adam
>