I am trying to write a small program to import data from vfp table and getting an error like this:"The VFPOLEDB.1 provider is not registered on the local machine"The OLEDB was installed and even tested it using the: SQL Server Business Intelligence Development Studio, and the connection was successful.I have a config file like this:<connectionStrings><add name="TestBulkCopy.My.MySettings.connSrc" connectionString="Provider=VFPOLEDB.1;Data Source=d:\temp\NY1_100000.dbf;Collating Sequence=MACHINE"providerName="System.Data.OleDb" /><add name="TestBulkCopy.My.MySettings.connDst" connectionString="Data Source=localhost;Initial Catalog=NY1;Integrated Security=True"providerName="System.Data.SqlClient" /></connectionStrings>
This is a test out of the SF project where I inted to incorporate that soon. Any idea what's the problem?Thanks,Doron