Keith..
How are you? At one Devcon, I know you went out with Rod and myself - as well as a few others. I hope all is well with you...
With respect to VFP, the big difference between ODBC and OLE-DB resets with whether you want your data rendered as a VFP cursor or an ADO Recordset object. Each has unique strengths and in practice, I use both.
One issue is whenever possible, if you are going to use OLE-DB, make sure you use the OLE-DB Provider for VFP as opposed to the ODBC Driver for VFP which is encompassed by the OLE-DB Provider for ODBC Drivers.
Man... That was a mouthful!
The OLE-DB Provider will provide better performance...
In sum, the issue is not whether you should use ODBC vs OLE-DB. IMO, both have utility in VFP. In fact DataClas/VFP (
www.redmatrix.com) makes use of both technologies.
The issue is that whenever you use OLE-DB, make sure you use the OLE-DB Provider for VFP.
HTH...