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: 365440 # Views: 38 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Wednesday, December 26, 2012 12:53:23 PM         
   


> sir thanks for reply.
> yes sorry for using offline word. i mean i am using vfp application that is connected to internet and i want to use database locate at remote location.
> can i use it like a local database?
>
> i have a client that uses biometric machines for attendance at different outlets. but want to see whole data at his office. so i want to use database at remote location and updated attendance data from his different outlet. i don't want to use any online application for this.
>
> i want to use my existing vfp application to connect to remote machine and update database.
>
> am i right?
> and what settings i should set?
> i have ip address and port setting available.
> please tell me.
>
> Rupesh Kumar Sharma
> Dhanisha Infotech
> Jaipur, India

Yes you can connect to remote SQL servers using IP or URL and interact them as if they are local (speed might be different depending on connection). Where you are connecting to is controlled with "server" parameter. Here are some samples:

server=1.2.3.4 - connect to default instance (based on user and pwd also) at IP 1.2.3.4
server=1.2.3.4,48000 - connect to default instance (based on user and pwd also) at IP 1.2.3.4 port 48000
server=1.2.3.4,48000\SQLExpress - connect to SQLExpress instance at IP 1.2.3.4 port 48000
server=www.myHostingCompany.com - connect to your hosting company

If you are using SQL Azure, then they give you the connection string. You can also check www.connectionStrings.com

You are saying you have IP address and port setting available, try connecting with that info (if there is a DBA where SQL server is ask him what the connection string is and if it is configure for remote connections. if not then maybe watch my videos on youtube as a helper - go to youtube and search accuSQL, you will see 4 parts video. Parts contain installation of SQL server in remote and configuring it on server and client as well).



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