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...