I have an oleDB connection set up to some VFP tables. When I drag a table from the Server Explorer to the designer area, I get an error when VS .Net tries to generate the SQL statement. Evidently, it is putting brackets [] around the table names, and this is causing the error. I have been able to successfully drag tables using the SQL Server .Net Provider and the Access (Jet) oleDB Provider. These both work as expected and without brackets.
I'm guessing this is another bug in the VFP provider. Does anyone else have this problem?