error with stdole.dll

[tis707]

Hi all

I used owc10.dll to do some calculations in web application ASP.NET 2.0

its working in my local system and when i placed in web server getting the following error

[Error]

Server Error in '/Tool' Application.


--------------------------------------------------------------------------------

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below

and modify your configuration file appropriately.

Parser Error Message: Could not load file or assembly 'stdole, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its

dependencies. The system cannot find the file specified.

Source Error:



Line 20: <add assembly="System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>

Line 21: <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

Line 22: <add assembly="stdole, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

Line 23: <add assembly="ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/>

Line 24: <add assembly="MSDATASRC, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></assemblies>



Source File: tool\web.config Line: 22

Assembly Load Trace: The following information can be helpful to determine why the assembly 'stdole, Version=7.0.3300.0, Culture=neutral,

PublicKeyToken=b03f5f7f11d50a3a' could not be loaded.



WRN: Assembly binding logging is turned OFF.

To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.

Note: There is some performance penalty associated with assembly bind failure logging.

To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].





--------------------------------------------------------------------------------

Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433


pls help me in resolving this

[/Error]

[mmetzger]

Have you verified that the dll is on the server, registered, and accessible to the ASP.NET service user?

[tis707]

Hi

Thanks for your reply

In server OWC11.dll is there , so i changed my code and checked it but i am getting the same error


Could not load file or assembly 'Microsoft.Office.Interop.Owc11, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified

Regards

[TheCPUWizard]

I would have to double check to be sure, but most of the Office DLL's are NOT licensed for use on a server in any case.....

[tis707]

Hi all,

  StringBuilder sb4 = new StringBuilder();
            sb4.Append("=GROWTH(");
            sb4.Append("{" + y14 + "," + y15 + "}" + "," + "{" + x14 + "," + x15 + "}" + "," + dblNozzPress + ")");
            string s5 = sb4.ToString();

            Microsoft.Office.Interop.Owc11.SpreadsheetClass SP = new Microsoft.Office.Interop.Owc11.SpreadsheetClass();

          //  double[] pra1 = { y11, y12 };
          //  double[] pra2 = { x11, x12 };
          //  object b2 = null;
          ////  fnc = excelApp.WorksheetFunction;
          // a11 =  excelApp.WorksheetFunction.Growth(pra1, pra2, b2, dblNozzPress);
            //    OWC10.SpreadsheetClass SP = new OWC10.SpreadsheetClass();

            a11 = SP._Evaluate(s1);

Now i am getting different exception.
--------------------------------------------------------------------------------

Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))
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.Runtime.InteropServices.COMException: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.



Stack Trace:


[COMException (0x80020005): Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))]
Microsoft.Office.Interop.Owc11.SpreadsheetClass._Evaluate(Object Expression) +0
Default3.CalcWatt() +2273
Default3.Page_Load(Object sender, EventArgs e) +221
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +33
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +47
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436


Pls help me in resolving this

in my local system i have

Microsoft Office XP Web Component and Microsoft Office 2003 Web Component

But on the web server I only have

Microsoft Office 2003 Web Component

is this a problem

Thanks

Regards