Subject RES: [firebird-support] external table problem
Author Gerson Machado - Yahoo
First, change the parameter on file firebird.conf to: ExternalFileAccess
= Full

And try again.

Gerson



-----Mensagem original-----
De: agung wibowo [mailto:agung_firebird@...]
Enviada em: domingo, 12 de dezembro de 2004 00:28
Para: firebird-support@yahoogroups.com
Assunto: RE: [firebird-support] external table problem



Hi Gerson, I have simple scenario. I work with win xp, just on my pc.
And I
have FB installed inside.

I use Firebird superserver default installed. Thank’s before



agung



_____

From: Gerson Machado - Yahoo [mailto:gersonamach@...]
Sent: 11 Desember 2004 20:47
To: firebird-support@yahoogroups.com
Subject: RES: [firebird-support] external table problem



I Agung, I have the scenario, perhaps equal yours and can help....

Please detail your scenario.

I have W2k Server, W2k3 Server Win XP, Linux Suse 9.1 and Novell 6.0.
I have FB installed in W2k Server, W2k3 Server, Win XP and Linux.

Where you FB was.

Gerson


-----Mensagem original-----
De: agung wibowo [mailto:agung_firebird@...]
Enviada em: sábado, 11 de dezembro de 2004 10:23
Para: firebird-support@yahoogroups.com
Assunto: RE: [firebird-support] external table problem





Thank's Helen,..

I did that, for many times. But not work's. I installed Firebird as
default.
And I never change my firebird.conf before.

I tried to restart my machine, and error was still appear. I don't know
what's wrong here.

I login to my computer as ADMINISTRATOR, then I login to my FBserver
(from
DDL client (IB EXPERT personal edition)) as SYSDBA. Or maybe I need to
configure others parameter at my Firebird.conf? the only one parameter
in my
firebird.conf that was configured by myself is ExternalFileAccess =
d:\data
so, what next? Please give me solution?

Thank's before



Agung





_____

From: Helen Borrie [mailto:helebor@...]
Sent: 11 Desember 2004 17:52
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] external table problem



* At 01:24 PM 11/12/2004 +0700, you wrote:

>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.

The examples in the Borl docs are very slack. You shouldn't be trying
to
create an external file in some default directory.

Roll back this transaction and begin again.

1. Create a directory where you are going to store external files.
Let's
suppose it is d:\files
and make sure that the owner of the firebird process has full privileges
to
it (this will be OK if you did the default install)

2. Check the firebird.conf file and find the parameter
ExternalFileAccess. If I recall correctly, its default looks like this:
# ExternalFileAccess = NONE

Remove the '#' and change this to:

ExternalFileAccess = d:\files

3. Shut down and restart the server.

4. Log in and attach to your DDL client.

5. Now, do the definition again; but this time supply the
fully-qualified
path to the file (the file need not exist).

CREATE TABLE EXT_TBL
EXTERNAL FILE 'd:\files\exfile.txt'
(
FNAME CHAR(10),
LNAME CHAR(20),
NEWLINE CHAR(2));

Note that on Windows the carriage return is 2 bytes, not one.

./heLen



.



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT
HYPERLINK
"HYPERLINK
"http://us.ard.yahoo.com/SIG=1295jidap/M=295196.4901138.6071305.3001176/
"http://us.ard.yahoo.com/SIG=1295jidap/M=295196.4901138.6071305.3001176/
D=groups/S=1705115386:HM/EXP=1102854267/A=2128215/R=0/SIG=10se96mf6/*htt
p://companion.yahoo.com"click here
HYPERLINK
"HYPERLINK
"http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
"http://us.adserver.yahoo.com/l?M=295196.4901138.6071305.3001176/D=group
s/S=:HM/A=2128215/rand=387424967"


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
HYPERLINK
"HYPERLINK
"http://groups.yahoo.com/group/firebird-support/"http://groups.yahoo.com
/group/firebird-support/"HYPERLINK
"http://groups.yahoo.com"http://groups.yahoo.com
/group/firebird-support/


* To unsubscribe from this group, send an email to:
HYPERLINK
"mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
"firebird-support-unsubscribe@yahoogroups.com


* Your use of Yahoo! Groups is subject to the HYPERLINK
"HYPERLINK
"http://docs.yahoo.com/info/terms/"http://docs.yahoo.com/info/terms/"Yah
oo! Terms of Service.



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 9/12/2004



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 9/12/2004



[Non-text portions of this message have been removed]






Yahoo! Groups Sponsor



ADVERTISEMENT

<HYPERLINK
"http://us.ard.yahoo.com/SIG=129mc3bel/M=294855.5468653.6549235.3001176/
D=gr"http://us.ard.yahoo.com/SIG=129mc3bel/M=294855.5468653.6549235.3001
176/D=gr
oups/S=1705115386:HM/EXP=1102859206/A=2455396/R=0/SIG=119u9qmi7/*http:/s
mall
business.yahoo.com/domains/> click here



<HYPERLINK
"http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S="http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=g
roups/S=
:HM/A=2455396/rand=175051512>



_____

Yahoo! Groups Links

* To visit your group on the web, go to:
HYPERLINK
"http://groups.yahoo.com/group/firebird-support/"http://groups.yahoo.com
/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
>

* Your use of Yahoo! Groups is subject to the Yahoo!
<HYPERLINK
"http://docs.yahoo.com/info/terms/"http://docs.yahoo.com/info/terms/>
Terms of Service.



[Non-text portions of this message have been removed]



Yahoo! Groups Sponsor

ADVERTISEMENT
HYPERLINK
"http://us.ard.yahoo.com/SIG=129214ni2/M=294855.5468653.6549235.3001176/
D=groups/S=1705115386:HM/EXP=1102904934/A=2455396/R=0/SIG=119u9qmi7/*htt
p://smallbusiness.yahoo.com/domains/" \nclick here
HYPERLINK
"http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455396/rand=443447292"


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
HYPERLINK
"http://groups.yahoo.com/group/firebird-support/"http://groups.yahoo.com
/group/firebird-support/


* To unsubscribe from this group, send an email to:
HYPERLINK
"mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
"firebird-support-unsubscribe@yahoogroups.com


* Your use of Yahoo! Groups is subject to the HYPERLINK
"http://docs.yahoo.com/info/terms/"Yahoo! Terms of Service.



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 9/12/2004



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.0 - Release Date: 9/12/2004



[Non-text portions of this message have been removed]