Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp ole db driver and cursor adapters
Message
From
10/08/2004 13:34:58
 
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00932083
Message ID:
00932104
Views:
20
I'm don't quite understand what you want to do. If you have a VFP 8.0 app, why not access the data natively? See my other comments interspersed below...

>Hi,
>
>Can I used the vfp ole db driver with a cursor adapter? Is this the same as ADO?

OLEDB is a low-level (read C) interface for access data. ADO is simply a COM wrapper around OLEDB. A CursorAdapter can connect to several types of data and handle the translation to VFP cursors automatically.

>
>Basically I have a vfp 8.0 app and I want to access a VFP 8 DBC and generate a cursor using the vfp ole db driver.
>
>What is the speed of vfp ole db compared to ODBC?

In general, OLEDB will be faster than ODBC because ODBC has additional overhead. Also, the VFP ODBC driver has not been updated since VFP 6.0. If your data has any features added since then (for example, AutoInc), then you will not be able to use ODBC.

>
>Thanks.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform