Windows Server 2008 R2 64bit (App Server) - DMZ
Windows Server 2008 R2 64bit (Oracle Server) - Internal network
Both servers have Oracle Client 32bit installed
Appserver is hosting: IIS and a Windows Application
Oracle Server is hosting only the 11g DB
On my IIS web application, it app connects to the Oracle DB without any issue.
However, when I run the Windows application (.NET 2.0 app), it kept prompting 'OraOLEDB.Oracle.1' provider is not registered when it tries to connect.
What we have tried:
1- REGSVR oraOLEDB11.dll
2. Verified registry key permission of Oracle that Users have Read access
Any idea what could be the problem?
Is the desktop app compiled with x86? or ANYCPU?
You can use CORFLAGS.exe to check it..
ANYCPU will cause it to run as a 64 bit app on a 64 bit box, so the app will look for 64 bit ORAOLEDB, which can result in that error since the 64 bit provider legitimately is not installed.
Hope it helps,