Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Michel Levy
  Where is Michel Levy?
 
 France
 Michel Levy
 To: rupesh sharma
  Where is rupesh sharma?
 jaipur
 India
 rupesh sharma
 Tags
Subject: RE: online sql to offline application
Thread ID: 365377 Message ID: 365431 # Views: 41 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 26, 2012 12:09:28 PM         
   


> sir really my idea is same like you.
> i have a database on server (i can use it on my website)
> but i want to use this database in my desktop application.
> i want to read/write data from that database (SQL).
> Is it possible?
> if yes then how?
> please help me.
>
>
> Rupesh Kumar Sharma
> Dhanisha Infotech
> Jaipur, India

--
Hi Rupesh

Samir is right in the explanation of SQL replication, but I don't think it is a good advice for 2 reasons (sorry Samir to disagree ;-) )

1) replication is not a simple operation to apply on a server, it is really out of range for a beginner.
Trust me, begin by using and using SQL server for 4 or 5 years, read books to understand how run the SQL machine, then try a replication on some development server and run the replication during a quarter. You'll see that MS theory is sometimes (often??) not as real world.
Replication is more a DBA job than a developper job!

2) having your SQL server on a remote machine, you need to know the IP adress of the server hosting your SQL Server, and then you use your database remotely (consider all the security rules and setting to apply). no need of any replication, use a remote SQL server as if it was local.

Michel L

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