Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Andy Kramek
  Where is Andy Kramek?
 Hot Springs Village
 Arkansas - United States
 Andy Kramek
 To: dheeraj kumar
  Where is dheeraj kumar?
 chandigarh
 India
 dheeraj kumar
 Tags
Subject: RE: vfp9 with sql server
Thread ID: 155358 Message ID: 155372 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: ODBC, ADO and OLEDB
Date: Monday, December 31, 2007 11:33:13 AM         
   


Dheeraj

> i m using adodb

Is there some reason for this? There are several reasons for NOT doing it this way...

[1] VFP is optimized to work via ODBC (which returns data as a native VFP cursor) rather than OLEDB (which returns a recordset object)
[2] VFP has numerous built in functions (including SPT, Remote Views and CursorAdapters) to handle, manipulate and control cursors and ODBC connections, but none at all for recordsets and OLEDB
[3] Any VFP control and specifically grids, can be bound directly to a cursor but not to recordsets
[4] In my experience, VFP is demonstrably faster retrieveing data via ODBC than with OLEDB - especially when dealing with large (more than few tens of records) result sets

If you are building an application, or middle tier component, in VFP that accesses data in SQL server, then you really should be using ODBC instead of OLEDB for your data access.

Regards
Andy Kramek
Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA

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