Can I install the "Visual FoxPro 7.0 OLE DB provider" without installing VFP 7? Is there an "Visual FoxPro 7.0 OLE DB provider" installer?
>You need to use the OLEDB provider that ships with VFP7 not ODBC. There are samples available about how to access VFP data using ADO.NET in the following whitepaper:
>
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnfoxgen7/html/usingaspnetwithvfp7.asp>
>
>>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.