An obscure body in the SK system. The inhabitants call it Earth
Posts
7,902
Re: Error
That provider is typically installed with Access although it comes with Excel as well. Have you installed them on your machine?
If you have then the problem could also be with the "bitness". If you try to use the 64 bit version on a 32 bit machine or vice versa you get that error.
The best argument against democracy is a five minute conversation with the average voter - Winston Churchill
Hadoop actually sounds more like the way they greet each other in Yorkshire - Inferrd
1) are you running this on a 64-bit OS?
2) If so, what is the platform setting "x86" or "64-bit" or "Any CPU"? If it is anything but, change it to "x86" see if that clears up the problem.
That provider is typically installed with Access although it comes with Excel as well. Have you installed them on your machine?
If you have then the problem could also be with the "bitness". If you try to use the 64 bit version on a 32 bit machine or vice versa you get that error.
If I remember right, the problem is that there is no 64-bit version... so if you are set to run in "Any CPU" and run it on a 64-bit OS, it will try to find the 64-bit version of the provider, which doesn't exist, and so the error. Changing it to "x86" forces the app into 32-bit mode, which will then correctly find the 32-bit version of the provider and all should be well. At least that's how I remember it being described.