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: dheeraj kumar
  Where is dheeraj kumar?
 chandigarh
 India
 dheeraj kumar
 Tags
Subject: RE: vfp9 with sql server
Thread ID: 155358 Message ID: 155376 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Monday, December 31, 2007 12:26:09 PM         
   


> 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

1) There is no best method for connection. Sometimes you may prefer ODBC and somethimes ADODB. It depends. One reason to use ADO might be to support new datatypes that VFP can't handle when used via ODBC driver. With VFP9's new support for ADO cursors, ADO has become more like a first class citizen. Bulk inserts for example now easier to handle with ADO rather than ODBC.
2) Commands executed against SQL server occur in a batch and as batch completes they're instantly available to all clients.
3) With SQL server it'd be as fast as or faster. SQL server, 2000 and later got faster than VFP in almost all areas. However, like you can do with VFP there are always ways to make the SQL server backend work slower. In other words, if it's slow first question your queries and strategy.

Cetin Basoz

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