Could not load file or assembly ‘stdole,

Product:

Cognos Controller 10.1 RTM

Windows 2008 R2 server

Symptom:

When start Cognos Controller client for the first time, it stop at the WSSurl value.

To try to troubleshoot you surf to http://servername/ibmcognos/controllerserver/ccrws.asmx.

 

Error Message:

Server Error in ‘/ibmcognos/controllerserver’ 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 36:         <add assembly=”ADODB, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A” />

Line 37:         <add assembly=”MSDATASRC, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A” />

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

Line 39:         <add assembly=”Microsoft.StdFormat, Version=7.0.3300.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A” />

Line 40:       </assemblies>

 

Source File: E:\Program Files (x86)\ibm\cognos\c10\ControllerProxyServer\web.config Line: 38

 

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.5448; ASP.NET Version:2.0.50727.5456

 

Cause:

Missing file “stdole.dll” on application server

 

Solution:

Install SQL 2005 32 client on Controller Applications server, including Workstation components, Books Online and development tools.

 

Or upgrade to latest version of Cognos Controller

 

More Information:

https://www-304.ibm.com/support/docview.wss?uid=swg21509303