Import data from VFP table

Doron Farber — Thu, 21 Aug 2008 10:42:42 GMT

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:

[codesnippet]<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>[/codesnippet]

This is a test out of the SF project where I inted to incorporate that soon. Any idea what's the problem?

Thanks,

Doron

RE: Import data from VFP table

Doron Farber — Thu, 21 Aug 2008 10:42:42 GMT

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

StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Import data from VFP table

Import data from VFP table

RE: Import data from VFP table