Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: dheeraj kumar
  Where is dheeraj kumar?
 chandigarh
 India
 dheeraj kumar
 Tags
Subject: RE: vfp9 with sql server
Thread ID: 155358 Message ID: 155359 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Monday, December 31, 2007 7:29:14 AM         
   


> hi experts
>
> i m trying vpf9 with sql server..
>
> presently i m using free tables..
>
> i have some quries..
>
> please help
>
> 1. what is the best method for connection
> 2. how to add, alter & delete records so that it will be avaible to all the
> clients instantly.
> 3. using free tables my app. performance is quite good. is it will be same with sql server.. any suggestions...
>
> kumardheeraj

Dheeraj

1. Check out the SQLCONNECT and SQLSTRINGCONNECT functions.
2. Check out the tutorial by Bernard Bout in the article section on cursor adaptors to 3. It depends since you will be moving from file server to data server. On a data server, the load on the network traffic will be reduced, but the load on the processing power of the server will increase. Normally, since the network is a major constraint and increasing the specs of the server is easier, the speed of SQL Server should be slightly more.

Regards
Tushar

ENTIRE THREAD

vfp9 with sql server Posted by dheeraj kumar @ 12/31/2007 7:11:53 AM
RE: vfp9 with sql server Posted by tushar @ 12/31/2007 7:29:14 AM
RE: vfp9 with sql server Posted by dheeraj kumar @ 12/31/2007 8:25:21 AM
RE: vfp9 with sql server Posted by suhas hegde @ 12/31/2007 11:00:18 AM
RE: vfp9 with sql server Posted by Andy Kramek @ 12/31/2007 11:33:13 AM
RE: vfp9 with sql server Posted by Cetin Basoz @ 12/31/2007 12:26:09 PM
RE: vfp9 with sql server Posted by Dinesh sharma @ 1/1/2008 10:22:40 AM
RE: vfp9 with sql server Posted by Ken Murphy @ 1/1/2008 4:11:32 PM