Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: rupesh sharma
  Where is rupesh sharma?
 jaipur
 India
 rupesh sharma
 Tags
Subject: RE: online sql to offline application
Thread ID: 365377 Message ID: 365436 # Views: 42 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 26, 2012 12:35:31 PM         
   


> > 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
>
> sir i have ip address of remote machine sql server. now can i use this database as local providing proper connection string?
>
> Rupesh Kumar Sharma
> Dhanisha Infotech
> Jaipur, India

You are confusing people saying offline. If you really mean offline (no connection to anywhere a standalone PC or notebook) then you surely cannot connect to an SQL Server in a remote machine. Then install the SQL server on that single computer.

If you mean it is a desktop application (as with almost any VFP application) that needs to connect to an SQL server on the internet then:
Can you connect? Yes, you can. We all do that daily. ie: I connect to servers all around the world (mostly for development and testing but would be the same for production).
It is basically a change in the connection string:

handle = SQLStringConnect("driver={SQL Server Native Client 11.0};server=1.2.3.4;uid=username;pwd=password")


1.2.3.4 represent the IP of the remote server. That part might need to be different depending on if it is configured on default port, have an instance name etc. It could also be a URL instead of IP such as www.mySQLHosting.com. Having just the correct location of SQL server is not sufficient. It should be enabled for remote connections and any firewall settings should have been set. Ask the connection settings to the DBA who manages the remote SQL server.



Cetin Basoz

.Net has got better.Think about moving - check my blog:
My Blog
Blog (mirror) - sounds to be down


Support Wikipedia

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