Exception : Unable to load DLL (OraOps9.dll) Error
This is the first time i switched from using SQL Server to Oracle with Visual Studio .NET. When i tried to make call to a strored procedure in the oracle database my code threw following exception :
"Unable to load DLL 'OraOps9.dll': The specified module could not be found."
There could be many solutions to this problem.
If you people faced this problem too then i hope the above discussion will help you out.
"Unable to load DLL 'OraOps9.dll': The specified module could not be found."
There could be many solutions to this problem.
- Firstly you can try with this. Grant read permissions to the Oracle home directory to the asp.net account(and possibly the iuser_machinename account). The oracle home directory isn't generally visible to non-interactive accounts. You may need read/execute on the oracle_home\bin directory.
- Other way, that i found out after a lot of research and that actually fixed my problem was that Oracle Data Provider for .NET (ODP.NET) was missing. You can get ODP.NET from the following location:
http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.html
Dont forget to to reboot your server after the installation.
If you people faced this problem too then i hope the above discussion will help you out.
No comments: