The 'MSDAORA.1' provider is not registered on the local machine The 'MSDAORA.1' provider is not registered on the local machine oracle oracle

The 'MSDAORA.1' provider is not registered on the local machine


Using ORAOLEDB.ORACLE rather than MSDAORA fixed the same issue for me - changing the platform target from 'Any CPU' to 'X86' caused errors within my project in Visual Studio.

See answer here


I figured out the solutions for this. The problem stemmed from running the machine on a 64bit machine. To change that in VS, open up the properties page of the solution and in the build tab change the targeted platform to x86. And that did the trick.

http://lostechies.com/gabrielschenker/2009/10/21/force-net-application-to-run-in-32bit-process-on-64bit-os/

Thanks for your help Yuriy.


I had the same issue, but I used another solution because my application is running in IIS.

In the advanced settings of the application pool I changed the value for Enable 32-Bit Applications to true.