There is a merge module that ships with VFP7 with installs the necessary files using InstallShield. It is used to install on client machines that need to use the provider. You would need to create your own installer that uses the merge module.
>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.
-----------------------------------------
Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.comwww.prenia.comWeblog: blogs.prenia.com/cathi