Last post Jun 08, 2008 06:55 AM by ian deswarte
Apr 22, 2008 07:22 AM|Darwood|LINK
I am connecting to a Visual Foxpro database in VWD2005. I have dragged a gridview control onto the design surface and stepped through the wizard to create an OLEDB datasource etc. The problem I have is that the data being returned is just the fieldnames.
The actual data does not seem to be returned. I think this could be because the select statement being generated has all of the fieldnames wrapped in square brackets  as when I select * for all fields this isn't a problem but it takes forever to get the
Has anyone else come across this problem using VWD2005 with accessing Visual Foxpro data via OLEDB provider?
Jun 08, 2008 06:55 AM|ian deswarte|LINK
I get the same problem using the VFP ODBC driver. As you say, removing the brackets solves the problem. Examining SQL syntax, I've no idea where the brackets are coming from. Probably just a bug in Visual Web Developer.