Subject Re: [firebird-support] create tbale EXTERNAL cmd usage
Author Osman ─░ZBAT
You must set the ExternalFileAccess section in firebird.conf .

karthick srini wrote:

>Dear Members,
>
>While I tried to create table in external file in ISQL
>, I have got an authorization exception. How to make
>it work. Below is the snippet from ISQL prompt.
>
>SQL> create table test external '\Temp\passwd.txt' (id
>char(80));
>Statement failed, SQLCODE = -902
>
>Access to external file "C:\TEMP\PASSWD.TXT" is denied
>by server administrator
>
> I tried with different types of files such as
>\Temp\passwd , etc. And I tried without and with the
>actual file as in the specified file spec(file
>location following external keyword external).
>
>Note: I logged in sysdba account (Administrator)
>
>Please do help in fixing this problem,
>
>S.Karthick
>
>
>
>_______________________________
>Do you Yahoo!?
>Shop for Back-to-School deals on Yahoo! Shopping.
>http://shopping.yahoo.com/backtoschool
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>