Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Samir Ibrahim
  Where is Samir Ibrahim?
 Chekka
 Lebanon
 Samir Ibrahim
 To: rupesh sharma
  Where is rupesh sharma?
 jaipur
 India
 rupesh sharma
 Tags
Subject: RE: online sql to offline application
Thread ID: 365377 Message ID: 365392 # Views: 70 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Tuesday, December 25, 2012 7:20:31 PM         
   


> hi all,
> i have another question about sql database.
> please clear me can i use sql database located at a server location for desktop (offline) application.
> means using connection string for server.
> if possible then please tell how?
> thanks in advance.
> Rupesh Kumar Sharma
> Dhanisha Infotech
> Jaipur, India

If I understand your requirement, that is possible.

Let say you have main server "A" exist on the interner, and server "B" exist on local network, and "C" which is a work station.

The word OFFLINE could have many meaning, but any way here it is

You must setup a merge (read/write) or snapshot (read) replication between server A (publisher) and server (B) subscriber, when you run the replication, all the tables with data will be replicated on server B from server A, and then you can connect the C to B and read the data even if there is no internet(offline)

The difference from Merge and Snapshot is in Merge when you modify the data on B, and when there is connection between A and B, the A data will be changed, while in snapshot no changes will occured on A whatever you do on data exsit on B.


Samir Ibrahim

ENTIRE THREAD

online sql to offline application Posted by rupesh sharma @ 12/25/2012 4:18:57 PM
RE: online sql to offline application Posted by David Mustakim @ 12/25/2012 4:48:27 PM
RE: online sql to offline application Posted by Michel Levy @ 12/25/2012 6:44:02 PM
RE: online sql to offline application Posted by Samir Ibrahim @ 12/25/2012 7:20:31 PM
RE: online sql to offline application Posted by rupesh sharma @ 12/26/2012 4:08:28 AM
RE: online sql to offline application Posted by Samir Ibrahim @ 12/26/2012 12:04:49 PM
RE: online sql to offline application Posted by Michel Levy @ 12/26/2012 12:09:28 PM
RE: online sql to offline application Posted by rupesh sharma @ 12/26/2012 12:17:46 PM
RE: online sql to offline application Posted by Cetin Basoz @ 12/26/2012 12:35:31 PM
RE: online sql to offline application Posted by rupesh sharma @ 12/26/2012 12:41:52 PM
RE: online sql to offline application Posted by Cetin Basoz @ 12/26/2012 12:53:23 PM
RE: online sql to offline application Posted by rupesh sharma @ 12/26/2012 1:03:32 PM
RE: online sql to offline application Posted by Samir Ibrahim @ 12/26/2012 12:20:48 PM
RE: online sql to offline application Posted by rupesh sharma @ 12/26/2012 12:35:32 PM
RE: online sql to offline application Posted by Samir Ibrahim @ 12/26/2012 12:59:47 PM
RE: online sql to offline application Posted by rupesh sharma @ 12/26/2012 1:05:54 PM
RE: online sql to offline application Posted by Michel Levy @ 12/26/2012 2:10:21 PM
RE: online sql to offline application Posted by Samir Ibrahim @ 12/26/2012 2:16:58 PM
RE: online sql to offline application Posted by David Mustakim @ 12/26/2012 12:37:46 PM
RE: online sql to offline application Posted by Samir Ibrahim @ 12/26/2012 1:05:36 PM
RE: online sql to offline application Posted by David Mustakim @ 12/26/2012 1:22:43 PM
RE: online sql to offline application Posted by Glen Villar @ 12/26/2012 1:48:34 PM