I tried to use it too. Never got it to working. Also, ODBC.NET providers are not tested for Fox drivers, hence doesn't make sense to use it in a production app.
Though, I wrote a simple code that gets XML from Fox and converts it to DataSet in .NET..Send me an email if you are interested...
>I cannot seem to connect to a VFP database using the oleDbConnection object.
>
>I have setup an ODBC connection to the directory that holds the free VFP tables and I am using the oleDbConnection object to access the tables via the "Microsoft OLE DB Provider for ODBC Drivers" which connects to the ODBC connection.
>
>How do I connect to a DBF table using ADO.NET?
>
>I get the following error:
>
>The .Net Data OLE DB Provider(System.Data.OleDb) does not support the MSDASQL Provider, Microsoft OLE DB Provider for ODBC Drivers.
- Jayesh