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]