Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Daniel Hofford
  Where is Daniel Hofford?
 Ocala
 Florida - United States
 Daniel Hofford
 Tags
Subject: RE: VPN Recovery
Thread ID: 143086 Message ID: 143105 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Network and Computer Management
Date: Friday, August 24, 2007 9:49:56 PM         
   


> >
> > If you have any new data types in your database, then use VFPOLEDB instead of ODBC (You must switch to CursorAdapters :o))
> >
> > -----------------
> > Borislav Borissov
> >
> > Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> > The only thing normal about database guys is their tables.
>
> Hi Borislav,
> I'm using DBF's that were created in FP 2.6. This is a legacy app. I'm also using DBF's created in VFP 9.0. These are the tables in the app that I wrote that interfaces between the legacy data and the Scheduler.
> I need to try and get VFPServer and client working as I will have to pull record sets from legacy tables with 300k + records. I need this to be processed on the server side.
> How does one recover from the loss of a connection in the middle of transferring data??
> Thanks,
>
> Dan
> "Our gold does not chink and glitter. It gleams in the sun and neighs in the dark." Chief Joseph

Simply, You can't.
You must use transactions, but if the connection fails the data is lost.
You can't recover it, or you can but you must keep a local database on every computer and the synchronize both databases IF the connection is lost somewhere between the transactions.


-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

VPN Recovery Posted by Daniel Hofford @ 8/24/2007 6:54:24 PM
RE: VPN Recovery Posted by Ken Murphy @ 8/24/2007 7:04:20 PM
RE: VPN Recovery Posted by Daniel Hofford @ 8/24/2007 9:07:57 PM
RE: VPN Recovery Posted by Ken Murphy @ 8/25/2007 1:56:00 AM
RE: VPN Recovery Posted by Daniel Hofford @ 8/25/2007 3:03:33 AM
RE: VPN Recovery Posted by Ken Murphy @ 8/25/2007 2:27:47 PM
RE: VPN Recovery Posted by Eric den Doop @ 8/24/2007 9:02:07 PM
RE: VPN Recovery Posted by Daniel Hofford @ 8/24/2007 9:09:55 PM
RE: VPN Recovery Posted by Borislav Borissov @ 8/24/2007 9:28:00 PM
RE: VPN Recovery Posted by Daniel Hofford @ 8/24/2007 9:44:41 PM
RE: VPN Recovery Posted by Borislav Borissov @ 8/24/2007 9:49:56 PM
RE: VPN Recovery Posted by Daniel Hofford @ 8/24/2007 9:56:24 PM
RE: VPN Recovery Posted by Borislav Borissov @ 8/24/2007 10:41:07 PM
RE: VPN Recovery Posted by Daniel Hofford @ 8/24/2007 10:46:28 PM
RE: VPN Recovery Posted by Borislav Borissov @ 8/24/2007 10:48:32 PM
RE: VPN Recovery Posted by tushar @ 8/25/2007 8:57:40 AM
RE: VPN Recovery Posted by Eric den Doop @ 8/25/2007 10:08:19 AM
RE: VPN Recovery Posted by Daniel Hofford @ 8/26/2007 2:11:00 AM
RE: VPN Recovery Posted by Eric den Doop @ 8/26/2007 9:30:23 AM
RE: VPN Recovery Posted by Daniel Hofford @ 8/26/2007 3:54:40 PM
RE: VPN Recovery Posted by Eric den Doop @ 8/26/2007 9:13:50 PM
RE: VPN Recovery Posted by Daniel Hofford @ 8/27/2007 12:26:18 AM
RE: VPN Recovery Posted by Daniel Hofford @ 8/26/2007 2:10:21 AM
RE: VPN Recovery Posted by tushar @ 8/26/2007 8:13:46 AM
RE: VPN Recovery Posted by Daniel Hofford @ 8/26/2007 3:57:07 PM
RE: VPN Recovery Posted by tushar @ 8/26/2007 4:27:33 PM