Hi!

I have started my development: I have tried using the Import and Export Wizard 32 Bit.

When I select the Microsoft OLE DB for Visual Foxpro, and click Next: I get the error "Invalid Path"

If I click on the "Properties" Button (there are no others): DTSWizard(32) hangs: and I have to kill it.

Is there a problem with VFPOLEDB? (it is part of Visual Foxpro 7)

Thanks : I am starting to learn SQL 2012: I intend to convert our legacy applications to SQL: and I would like help in improting and exporting from VFP.

Mohan

When I select the Microsoft OLE DB for Visual Foxpro, and click Next: I get the error "Invalid Path"

Hello Mohan,

AFAIK is the VFP data provider not part of MDAC or included in OS. Have you installed the latest version of the data provider, which is supported for the OS you are using? Can you create a ODBC DSN with that provider, pointing to your VFP database?

Hi Olaf      4 Dec

Let me make my situation clear:

OS is Windows Server 2008 R2 64 bit

SQL is SQL Server 2012 Express. The 64 bit version is installed

The VFPOLEDB.DLL is present after installation of VFP7 on the server.

I have not yet tried creating a DSN: will try today.

I tried the following in Management Studio ( Entered each line as a separate new query, and clicked Execute. Each command was executed successfully)

sp_configure 'show advanced options', 1;
sp_configure 'Ad Hoc Distributed Queries', 1;
EXEC master.dbo.sp_MSset_oledb_prop N'VFPOLEDB', N'AllowInProcess', 1
EXEC master.dbo.sp_MSset_oledb_prop N'VFPOLEDB' , N'DynamicParameters' , 1

select * into bnmtemp from openrowset('VFPOLEDB','d:\windows\sysvol\sysvol\bnm\prdpl\order\temp.dbf';'';'','select * from temp.dbf')

I now get the error "The 32 bit OLE DB provider "VFPOLEDB" cannot be linked in-process on a 64 bit SQL Server"

Does this now mean that SQL 2012 64 bit cannot access Foxpro Tables? I successfully imported from an Excel 2003 worksheet. The Excel application is 2007 32 bit.

Will the installation of the latest VFPOLEDB (for VFP9 make any difference? (it has to some people, but I am not sure if the 64 bit SQL situation was replicated)

Wish I could get a clear course:  wonder if should install the 32 bit version of SQL 2012 Express  also?

Also, are the commands  executed 'Persistent'

Would be thrilled to get some help.

Mohan

I now get the error "The 32 bit OLE DB provider "VFPOLEDB" cannot be linked in-process on a 64 bit SQL Server"

Does this now mean that SQL 2012 64 bit cannot access Foxpro Tables?

Hello Mohan,

Indeed, with a 64 application like SQL Server you can only use 64 bit data provider and I don't think there is a 64 bit provider for VFP available. Excel 2003 is a 32 bit application, here you can use the provider.

You could install SQL Server as 32 bit (as additional instance), or you could use Excel to import the data from VFP, afterwards you could import the data from the Excel file to SQL Server.

Hi Olaf!

Thanks!

I propose to install a new instance of SQL 2012 Express 32 bit alongside the 64 bit tomorrow.

I do not know how much trouble I will have in interfacing my live FoxPro systems with SQL.

Import into 32 bit from Foxpro

Import into 64 bit from 32 bit.

Develop master maintenance screens in SQL 64.

Develop export to 32 bit from 64 bit

Develop export to Fox from 32 bit

Disable updates in Fox.

Repeat above live to go live for one module.

Hope I live long enough to transfer 30 years of Fox development to SQL!

Thanks again.

Mohan