Subject Re: [firebird-support] External tables and FB 1.5
Author Helen Borrie
At 11:10 AM 20/04/2004 +0200, you wrote:
>Yes indeed 'Full' is bad idea. It was more for the principle to use it,
>to see it it has the desired effect.
>I stopped and restarted the server, but still it did not work. The file
>firebird.conf seems to be at the
>right place. The registry tells the right path and it it one directory
>level above firebird.exe

Hmm, I just did the following on my system (Win2K), same build as yours:

1. Commented out my settings for ExternalFileAccess.
2. Added the following:
ExternalFileAccess = Full
3. Saved firebird.conf
4. Stopped and restarted the server
5. Created an external table and put some data in:

create table ext_table
external file 'l:\data\ext_table.txt' (
field1 char(10),
field2 char(10));
commit;
insert into ext_table
values('muscles999', 'arteries00');
commit;
6. Disconnected from database.
7. Opened ext_table.txt:

muscles999arteries00

So it's all working on this system...

/heLen