Had same message. It worked for me after changing in 'firebird.conf'

#ExternalFileAccess = None
to
ExternalFileAccess = full

Better remove that later on I guess :)
-----------------------------------------------------------

----- Original Message -----
From: "Oleg Lebedev" <oleg.lebedev@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, September 29, 2003 1:41 PM
Subject: RE: [firebird-support] Import data from flat files


|
| Hmm, I have access to a Win machine, but I need to figure out how to
| this on Linux.
|
| External tables solution sounded like a good idea. But every time I try
| to create my table using the:
|
| Create Table Orders External '/tmp/orders.tbl' (.....);
|
| It throws an error saying that "Access to external file /tmp/orders.tbl
| is denied by server administrator". I checked the read/write permissions
| on this file to allow reads, but still have the same problem.
| Ideas?
|
| Thanks.
|
|
| -----Original Message-----
| From: Rafael Szuminski [mailto:raf@...]
| Sent: Monday, September 29, 2003 1:14 PM
| To: firebird-support@yahoogroups.com
| Subject: Re: [firebird-support] Import data from flat files
| Importance: Low
|
|
| uh, yeah... that would be a problem ;-)
|
| Do you have any Windows machines on the network that you could transfer
| the data from? I always do all my 'data' work on the Windows and then
| copy the ready file to the Linux server.
|
| Raf
|
|
| Oleg Lebedev wrote:
|
| > It doesn't seem to work on Linux.
| >
| > -----Original Message-----
| > From: Rafael Szuminski [mailto:raf@...]
| > Sent: Monday, September 29, 2003 12:53 PM
| > To: firebird-support@yahoogroups.com
| > Subject: Re: [firebird-support] Import data from flat files
| > Importance: Low
| >
| >
| > How about IBPump?
| > (http://www.clevercomponents.com/products/datapump/ibdatapump.asp)
| >
| > Just copy the data out of MSSQL or any other ADO data source.
| >
| > Raf
| >
| >
| > Oleg Lebedev wrote:
| >
| >
| >>Sory, I fogot to mention that I need to be able to import files into
| >>the FireBird database running on Linux RedHat 8.0. I have 1 GB of data
| >
| >
| >>to import, so I need a pretty fast utility for that. The best would be
| >
| >
| >>a similar to GBAK utility that can import data from flat files into DB
| >
| >
| >>tables. Any ideas?
| >>Thanks.
| >>
| >>Oleg
| >>
| >>
| >>-----Original Message-----
| >>From: M Tuttle [mailto:miket@...]
| >>Sent: Monday, September 29, 2003 11:15 AM
| >>To: firebird-support@yahoogroups.com
| >>Subject: Re: [firebird-support] Import data from flat files
| >>Importance: Low
| >>
| >>
| >>SMImport at http://www.scalabium.com/
| >>
| >>----- Original Message -----
| >>From: "alecswan2001" <oleg.lebedev@...>
| >>To: <firebird-support@yahoogroups.com>
| >>Sent: Monday, September 29, 2003 11:03 AM
| >>Subject: [firebird-support] Import data from flat files
| >>
| >>
| >>
| >>
| >>>I am trying to run some TPC benchmarks on the FireBird database. I
| >>>have just performed these tests on PostgreSQL by importing data from
| >>>the flat files and running TPC-R queries. Is there a FireBird utility
|
| >>>that would read data from comma- separated flat files and insert data
|
| >>>into the tables? Something similar to the COPY command in PostgreSQL
| >>>that copies data from a file to a table.
| >>>
| >>>Thanks.
| >>>
| >>>Oleg
| >>>
| >>>
| >>>
| >>>To unsubscribe from this group, send an email to:
| >>>firebird-support-unsubscribe@yahoogroups.com
| >>>
| >>>
| >>>
| >>>Your use of Yahoo! Groups is subject to
| >>>http://docs.yahoo.com/info/terms/
| >>>
| >>>
| >>>
| >>
| >>
| >>
| >>
| >>
| >>To unsubscribe from this group, send an email to:
| >>firebird-support-unsubscribe@yahoogroups.com
| >>
| >>
| >>
| >>Your use of Yahoo! Groups is subject to
| >>http://docs.yahoo.com/info/terms/
| >>
| >>*************************************
| >>
| >>This e-mail may contain privileged or confidential material intended
| >>for the named recipient only. If you are not the named recipient,
| >>delete this message and all attachments. Unauthorized reviewing,
| >>copying, printing, disclosing, or otherwise using information in this
| >>e-mail is prohibited. We reserve the right to monitor e-mail sent
| >>through our network.
| >>
| >>*************************************
| >>
| >>
| >>To unsubscribe from this group, send an email to:
| >>firebird-support-unsubscribe@yahoogroups.com
| >>
| >>
| >>
| >>Your use of Yahoo! Groups is subject to
| >>http://docs.yahoo.com/info/terms/
| >>
| >>
| >>
| >
| >
|
| --
| Rafael Szuminski
| Email:raf@...
| Phone:(949)939 - 2458
| www.BDCSoftware.com
|
|
|
| To unsubscribe from this group, send an email to:
| firebird-support-unsubscribe@yahoogroups.com
|
|
|
| Your use of Yahoo! Groups is subject to
| http://docs.yahoo.com/info/terms/
|
| *************************************
|
| This e-mail may contain privileged or confidential material intended for
the named recipient only.
| If you are not the named recipient, delete this message and all
attachments.
| Unauthorized reviewing, copying, printing, disclosing, or otherwise using
information in this e-mail is prohibited.
| We reserve the right to monitor e-mail sent through our network.
|
| *************************************
|
|
| To unsubscribe from this group, send an email to:
| firebird-support-unsubscribe@yahoogroups.com
|
|
|
| Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|
|
|