Subject | Re: [firebird-support] External tables and FB 1.5 |
---|---|
Author | Helen Borrie |
Post date | 2004-04-20T11:38:59Z |
At 11:10 AM 20/04/2004 +0200, you wrote:
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
>Yes indeed 'Full' is bad idea. It was more for the principle to use it,Hmm, I just did the following on my system (Win2K), same build as yours:
>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
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