Geek Answers Handbook

Provider "MSDAORA.1" is not registered on the local machine

I have an application that connects to a database, extracts information, creates an excel file, and then deletes the file / email to X people.

The application was created in Visual Studios using the .NET 2.0 Framework (Windows Form App). It started on a 32-bit server. But recently it has been ported to a 64-bit server. Now it returns with the error "The provider" MSDAORA.1 "is not registered on the local computer."

I believe that MSDAORA is only supported for 32-bit applications, and the application pool running in IIS is not enabled for 32-bit applications.

How can I fix this problem, is there something that I can change in IIS? Or is it a code change?

+4
source share
4 answers

I understood the solutions for this. The problem is related to starting the machine on a 64-bit machine. To change this in VS, open the solution properties page and on the build tab, change the target platform to x86. And this is a trick.

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

Thank you for your help, Yuri.

+2
source

Using ORAOLEDB.ORACLE, and does not MSDAORAfix the same problem for me - changing the target platform from "Any processor" to "X86" caused errors in my project in Visual Studio.

See the answer here

+4
source

, , IIS.

Enable 32-Bit Applications true.

+1

, 32/64bit. xcopy ODAC cmd.exe . , . xcopy , DLL regsvr32 .

0

More articles:


All Articles