Neil,
>Rather than adding an SqlDataAdapter to the design surface, I added an OleDbDataAdapter. Everything went as to plan up until step 11, configuring the Data Adapter. Below please find the results of the wizard attempting to configure the Data Adapter.
Unfortunately, it looks like you're running into issues with the VFP OLE DB Provider. I've run into this on the OrderDetails table but haven't had the time to figure out what's up.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com