Talking databases

[Nathan Lehman]

That is a wonderful solution.  I like it a lot. However, we are a
somewhat small company and was hoping for a free solution.

> -----Original Message-----
> From: GCC Consulting [mailto:gccconsulting at comcast.net]
> Sent: Monday, January 09, 2006 4:33 PM
> To: 'Nathan Lehman'; filepro-list at lists.celestial.com
> Subject: RE: Talking databases
> 
> 
> 
> -----Original Message-----
> From: filepro-list-bounces at lists.celestial.com
> [mailto:filepro-list-bounces at lists.celestial.com] On Behalf Of Nathan
> Lehman
> Sent: Monday, January 09, 2006 3:55 PM
> To: filepro-list at lists.celestial.com
> Subject: Talking databases
> 
>             Hello all.  Here's my situation: We have two databases,
one
> real
> and one is for testing purposes (although the two databases do run on
the
> same file server).  Is it possible to pass information between the two
in
> real-time?
> Now I know the perfect solution of the two databases being able to
look up
> information from each other in real-time is probably not an option.
> Believe me, most guys my age have fantasies about being a rich
> athlete/actor/musician with more adoring fans than one could handle,
but
> not
> me, I dream of an ODBC compliant filePro.  So since I probably won't
ever
> get either of those dreams, are there any suggestions for another
> approach?
> Anybody else ever done anything like this?  I guess the easiest/only
way I
> can think of is to export the data from both databases and import them
> into
> the opposite databases.  This would have to be scheduled and wouldn't
be
> real-time but it is the best I can come up with.  Any help/suggestions
> would
> be appreciated.
> Oh, by the way, we run filePro 5.0.14 on a novell server with lots of
> little
> windows 2000/xp clients.
> 
> Nathan Lehman
> S & S Steel Services, Inc.
> Nathan at sssteelservices.com
> 765.622.4545 x253
> 
> Upgrade to fpODBC
> 
> Create an odbc database by any method
> 
> Link both databases through the odbc database.  Values will be passed
from
> one to the other.
> 
> These are probably other ways to do this using programming languages
> outside
> fp.
> 
> Richard Kreiss
> GCC Consulting
>