Hello Louis,

> I would appreciate it if someone can help me please. . .
>
> I am trying to create a external table, the text file is copied in the

same

> location as my database.
>
> This is the syntax I am using to create the table :
>
> CREATE TABLE CODES_EXTERNAL EXTERNAL FILE 'DIAGNOSIS.txt'
> (CODE CHAR(6), DESC CHAR(25), EOL_FIELD char(2));
>
> If I run the script, I get the following error:
>
> Unsuccessful execution caused by a system error that precludes
> successful execution of subsequent statements.
> Access to external file "DIAGNOSIS.TXT" is denied by server administrator.
>
> The funny thing is, I am the server administrator and no security has been
> set up for this specific file.
> OS : WinXP Pro
> FB 1.52
>
> If I add the path to the textfile in the create table statement, the same
> error occures.
>
> I guess there is something else causing this.

Check the Firebird configuration file. External table access is disabled
by default.

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com