Maritimed
asked on
Install the Microsoft VFPOLEDB Provider on Windows 8 64 bit
I've searched widely and tried anything I can think of to install the VFPOLEDB provider for VFP on my new Windows 8 machine with no success.
I downloaded both the MSM and MSI files from http://www.microsoft.com/en-us/download/details.aspx?id=14839, ran them as Administrator, the installation appears to run just fine, but when I try to access data from my application I get an error that the OLE DB provider is not found.
I have installed the provider before on other Windows 8 computers which I now suspect may have been 32-bit, as I did not have any difficulties with them working.
I also have it working on my previous workstation, which was migrated from Vista->Win7->Win8 and is running 64bit. It had been installed somewhere along the way during my use of the computer...
What do I need to do to get this installed and working in this environment?
I downloaded both the MSM and MSI files from http://www.microsoft.com/en-us/download/details.aspx?id=14839, ran them as Administrator, the installation appears to run just fine, but when I try to access data from my application I get an error that the OLE DB provider is not found.
I have installed the provider before on other Windows 8 computers which I now suspect may have been 32-bit, as I did not have any difficulties with them working.
I also have it working on my previous workstation, which was migrated from Vista->Win7->Win8 and is running 64bit. It had been installed somewhere along the way during my use of the computer...
What do I need to do to get this installed and working in this environment?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just FYI, the last FoxPro SP hot fix was released in April 2009, so the last supported OS is not just XP... VFP OLE DB provider is a little bit older than above mentioned hot fix.
OTOH, FoxPro is a C++ application based on Win32 API Windows subsystem so it should run under each OS which supports Win32 API (incl. WinE under Linux). Of course, you may find some small incompatibilities beginning with Windows 8 but it is nothing which could stop VFP applications. More serious problem are incompatible components from the 3rd party vendors.
OTOH, FoxPro is a C++ application based on Win32 API Windows subsystem so it should run under each OS which supports Win32 API (incl. WinE under Linux). Of course, you may find some small incompatibilities beginning with Windows 8 but it is nothing which could stop VFP applications. More serious problem are incompatible components from the 3rd party vendors.
ASKER
As you suspected, I was using MS Office Excel 64 bit. Once I installed the 32 bit version, my application again works as expected.
Thank you very much for your help!
Thank you very much for your help!
As stated by pcelba, compiling the application for 32-bit solves the problem with Access, and I suspect that it would do the same for FoxPro.
If you are unable to compile, you might try to run the application in compatibility mode for an older version of Windows. Since older versions did not support 64-bit, I suppose that the system adjust for 32-bits when doing so.
To run in compatibility mode, you need to locate the .exe on the hard drive (not a shorcut), right click on it and select the Compatibility tab. Note that in order to enable compatibility mode for XP, which was the last officially supported OS for FoxPro, the application needs to be installed in Program Files (x86).