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.

  1. 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.
  2. 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:

Followers

Powered by Blogger.