BTW for a quick test
-create a web form
-add an oledbadapter
-Choose VFPOLEDB and point to testdata.dbc
-Right click on adapter to generate dataset
-Add a datagrid
-Set datasource to dataset and datamember to table
-Dblclick page to get onload event
There add
oledbadapter1.fill(dataset1,"customer");
datagrid1.databind();
F5 to check.
Cetin
>I got it you were LOL at answer :) It works with VFP OLEDB driver :)
>Cetin
>
>>Sorry. To clarify:
>>
>>
This is my question>>>>Does ADO.NET require a special OLEDB provider, or should it work with the VFP7 one?>>
>>
>>
This is what was printed in March 2002 .Net Developer magazine>>>>Question: I can access a FoxPro database in ASP, but I can't do it in ASP.NET. I think it's possible with ODBC.NET, but that doesn't work. Could you give me a URL or example where a FoxPro database is used in ASP.NET? Thanks. Frederik Vannieuwenborg
>>>>
>>>>Answer: Well, Frederik, unfortunately, this is a simple question to answer. As of this writing there isn't an ADO.NET OLEDB provider for FoxPro, and the ODBC.NET Data Provider has only been tested with Microsoft SQL ODBC Drive, Microsoft ODBC Driver for Oracle, Microsoft Jet ODBC Provider.