Does the VFP OLE DB Provider work with VS Tools?

Unfortunately, the VFP OLE DB Data Provider does not always work with the OLE DB Command Builder or Data Adapter Wizard.

For more information, check out the MSDN Problem report:

http://support.microsoft.com/?id=316548

From what we've seen, the VFP OLE DB Data Provider works better with the Command Builder than it does with the Data Adapter Wizard. However, if you run into problems inserting, updating, or deleting Visual FoxPro data, you need to manually code the SelectCommand, UpdateCommand, DeleteCommand, and InsertCommand properties of the DataAdapter.