Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Good ADO book for VFP 9
Message
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01132448
Message ID:
01132837
Views:
14
>We have an application that relies nearly exclusively on cursoradapters. The current version works exclusively through ODBC (three back-ends, SQL server and Sybase Anywhere and open source firebird).
>
>What would be the benefit, if any, of changing the "data source" from ODBC to ADO? I cannot see any at the moment!

There are places where ADO works better, specifically if you're dealing with UniCode data (not supported at all by ODBC) and when dealing with stored procedures and parameter passing.

But in most cases - especially if you are returning data back - ODBC is considerably faster than ADO to get data. If you can use ODBC for data access by all means should you use it!
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform