4 Replies Latest reply: Nov 6, 2012 5:53 AM by Tridus RSS

    oracle

    SAMBIT RAY
      from which site download OraOps10w.dll

      plz help
        • 1. Re: oracle
          Hoek
          What are you trying to do? Please be more specific.
          If this has to do with an installation error you're trying to overcome then check the Installation Forum @ Database Installation or just do a complete reinstall.

          Be aware that this is the SQL and PL/SQL Forum and you're question doesn't seem related to (PL/)SQL in any way.
          • 2. Re: oracle
            SAMBIT RAY
            Actually website Application developed in .net 2005 and oracle 10g but
            in my system .net 2008 and oracle 10xe is there so when i run the application i got the following error.


            Server Error in '/SmsGateWay' Application.
            Unable to load DLL 'OraOps10w.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
            Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

            Exception Details: System.DllNotFoundException: Unable to load DLL 'OraOps10w.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)

            Source Error:

            Line 53: OracleParamArray[2] = new OracleParameter("oCursor_validate_user", OracleDbType.RefCursor);
            Line 54: OracleParamArray[2].Direction = ParameterDirection.Output;
            Line 55: resultSet = ORACLEHelper.ExecuteDataSet(ConnectionString, CommandType.StoredProcedure, "P_Get_login_dtl", OracleParamArray);
            Line 56: if (resultSet.Tables[0].Rows.Count != 0)
            Line 57: {                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
            • 3. Re: oracle
              Hoek
              Thanks for elaborating.
              Your problem seems related to ODP.NET, it's forum is @ https://forums.oracle.com/forums/category.jspa?categoryID=44

              Perhaps these threads might be of interest en will help you further:
              Unable to load DLL 'OraOps10w.dll': Access is denied.
              Unable to load DLL 'OraOps10w.dll'
              OraOps10.dll and OraOps10w.dll issue

              Don't forget to mark your question as 'answered', since it is not related to SQL or PL/SQL.
              • 4. Re: oracle
                Tridus
                That error is caused by not having an Oracle client installed. You can get one here: http://www.oracle.com/technetwork/topics/dotnet/downloads/index.html