Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Taking Inventory On-Line
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Web
Miscellaneous
Thread ID:
01567362
Message ID:
01568146
Views:
104
The main reason is because OleDb drivers are a pain from VFP. Lots of weird inconsistencies and things that don't work. Plus the only thing that really uses it (with auto-conversion to VFP data) is the DataAdapter which all in itself is oddball funky technology.

It used to be there were a few features that only the OleDb provider provided like Unicode transcoding, but that's actually been added in VFP 9 with the Odbc drivers as well.

Even if it weren't discontinued I'd stick with ODBC as the more reliable, universally used and overall simple low level technology that just works.

+++ Rick ---

>HI Craig, why (in a nutshell) is oledb not recommended?
>
>>No. You have to use ODBC or OLEDB (not recommended)
>>
>>>Bill: I think that I am the one who is confused. Will VFP7 read a SQL Server table directly??
>>>Randy
+++ 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