StrataFrame Forum

Import data from VFP table

http://forum.strataframe.net/Topic18648.aspx

By Doron Farber - 8/21/2008

Hi Trent,

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
By Doron Farber - 8/21/2008

Hi All,

The problem has been re-solved since I have a 64bits OS and I had to change the target Compile in the project properties to 32 bits. Edhy had the same problem before and suggested the above. Both of us are using Windows Vista Ultimate 64 bits.

Regards,

Doron