Subject RE: [firebird-support] External File Construction
Author Epstein, Ed
Its the end-users themselves. remote users would have the data packaged up
and sent to a server where it would it would then be inserted. So all
inserts would be done on the same local network where the IB server resides.
admin users or "staff" would also be on the local network performing inserts
of data we receive through other channels.

Edwin Epstein
> Continuity Partners Inc.
> 2753 S. Highland Dr.
> Suite 1010
> Las Vegas, Nevada 89109
> (702) 851-7850 Ext. 247
> eepstein@...
>
CONFIDENTIALITY NOTICE: The information contained in this message may be
privileged and confidential and protected from disclosure.
If the reader of this message is not the intended recipient, or an employee
or agent responsible for delivering this message
to the intended recipient, you are hereby notified that any dissemination,
distribution or copying of this communication is
strictly prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer.




-----Original Message-----
From: Alan McDonald [mailto:alan@...]
Sent: Monday, February 09, 2004 4:33 PM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] External File Construction


> I don't know how to program in Delphi or C++. I would not be
> able to create
> a DLL from the available component sets. That is certainly a
> solution that
> allows me to maintain the front-end at 90%+ VB. The time-frame is what is
> so critical here. I am managing an older system that very
> quickly needs to
> migrate to Interbase. It was Access based. I need to have this in a
> front-end that can be used on multiple systems at the same time and be
> multi-threaded. While an administrator is importing 1.2 million records
> he/she needs to be able to pull up other reports, manage other
> information,
> look-up tables, prefs, etc. Well over half the front-end is
> already built.
> I have enough experience with stored procedures, and help with it
> as well to
> manage the data in Interbase. My only major hurdle is getting
> the data into
> Interbase. From there I can deal with it. I have been managing
> and working
> on this system for 6 months. As long as I can continue to deliver working
> results I stay alive. To say that Access is being pushed well past its
> limits is a HUGE understatement right now. My database is
> growing by about
> 3 million records a month. VERY soon it will break Access since
> it just will
> not be able to handle that many updates at one time. I did not choose
> Interbase. Its a requirement since other systems are already on it and
> being coded in it. I am already a huge fan of Interbase (except for the
> fact it does not record the amount of records in a table!), but I am VB
> programmer :( So with this time-frame in effect, I don't have
> the amount of
> time neccessary to start working in Delphi and C++ and build my classes,
> objects, dll's etc. I think it would take me months to gain the
> neccessary
> skills to write in Delphi and C++ what I can write in VB.
>
>
> The only thing I dont understand is that VB is a popular language.
> Interbase HAS to be popular out there especialy since it is fairly
> powerfull, flexible and FREE. The two have to meet somewhere, but
> everywhere I go its Delphi, C++, everything-but-vb, etc.
>
>
> Edwin Epstein

Do your endusers need to pump this data regularly or do your admin staff
need to do it?
If it's the latter then I would recommend using the clevercomponents
datapump software to pump data from any ADO source to Firebird.
Not use if you need mountains of data each day/month or if its just a
"one-off" data movement you really are after.
Alan






Yahoo! Groups Links