| Subject | external table problem | 
|---|---|
| Author | agung wibowo | 
| Post date | 2004-12-11T06:24:07Z | 
Hi,..
I learn about Firebird external file. I never use external file before, then
I try to declare my query like this :
 
CREATE TABLE EXT_TBL EXTERNAL FILE 'exfile.txt'
(FNAME CHAR(10),
LNAME CHAR(20),
NEWLINE CHAR(1));
 
But I got error :
 
"Cannot commit transaction:
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Access to external file "file.txt" is denied by server administrator."
 
I try to create exfile.txt, and I locate this file to some directory, and I
try to redeclare my query with file path..
But I still get error. Can somebody help me??
Winxp, Firebird 1.5.1 superserver.
 
Regards,
agung
 
[Non-text portions of this message have been removed]
            I learn about Firebird external file. I never use external file before, then
I try to declare my query like this :
CREATE TABLE EXT_TBL EXTERNAL FILE 'exfile.txt'
(FNAME CHAR(10),
LNAME CHAR(20),
NEWLINE CHAR(1));
But I got error :
"Cannot commit transaction:
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Access to external file "file.txt" is denied by server administrator."
I try to create exfile.txt, and I locate this file to some directory, and I
try to redeclare my query with file path..
But I still get error. Can somebody help me??
Winxp, Firebird 1.5.1 superserver.
Regards,
agung
[Non-text portions of this message have been removed]