If I drag and drop a SQL table to a web form I get a connection and adapter created. Nice!

If I drag a Visual Foxpro table to a web form or a table from the IBM AS/400 I get an error message: "The wizard detected the following problems when configuring the data adapter for "mytable". Details: Generated SELECT statement. There were errors configuring the data adapter."
Not Good!

I have tried the following providers and I get the error message for all of them:
Microsoft OLE DB Simple Provider
Microsoft OLE DB Provider for Visual FoxPro
Microsoft OLE DB Provider for ODBC Drivers

Any suggestions? Thank you in advance.