Subject | [firebird-support] Using external tables |
---|---|
Author | Codebue Fabio - P-Soft |
Post date | 2007-10-24T20:17:41Z |
I'm just trying to use external tables to import data from other
programs....
I'm working with 2.03 for windows and after create a 2.0 fdb database I'm
tryin using ibexpert to create an external tables using follow instruction:
CREATE TABLE "_CLIFRE01"
EXTERNAL FILE 'C:\ExternalTables\seq-FRE01.csv' (
PROGRESSIVO TPROGRESSIVO /* TPROGRESSIVO = INTEGER */,
RIGAVIDEO TRIGAVIDEO /* TRIGAVIDEO = SMALLINT */);
Naturally in firebird.conf I set
ExternalFileAccess = 'C:\ExternalTables'
And I have restarted the server.
Error returned is: Cannot set database access mode for archive dump
Codebue Fabio
.-----------------------------.
_ \ __| _||
__/____|\__ \ _ \ _| _|
_| ____/\___/_| \__|
P-Soft di Codebue Fabio & C. sas
via B.Storti, 19
24060 - Chiuduno - BG
Italy
Phone: +39.030.839435
Fax: +39.030.5100306
Mobile: +39.348.3515786
.-----------------------------.
Web : www.p-soft.biz
EMail: f.codebue@...
programs....
I'm working with 2.03 for windows and after create a 2.0 fdb database I'm
tryin using ibexpert to create an external tables using follow instruction:
CREATE TABLE "_CLIFRE01"
EXTERNAL FILE 'C:\ExternalTables\seq-FRE01.csv' (
PROGRESSIVO TPROGRESSIVO /* TPROGRESSIVO = INTEGER */,
RIGAVIDEO TRIGAVIDEO /* TRIGAVIDEO = SMALLINT */);
Naturally in firebird.conf I set
ExternalFileAccess = 'C:\ExternalTables'
And I have restarted the server.
Error returned is: Cannot set database access mode for archive dump
Codebue Fabio
.-----------------------------.
_ \ __| _||
__/____|\__ \ _ \ _| _|
_| ____/\___/_| \__|
P-Soft di Codebue Fabio & C. sas
via B.Storti, 19
24060 - Chiuduno - BG
Italy
Phone: +39.030.839435
Fax: +39.030.5100306
Mobile: +39.348.3515786
.-----------------------------.
Web : www.p-soft.biz
EMail: f.codebue@...