I have en error when migrating my project from Microsoft Windows Server 2003 Enterprise to Microsoft Windows Server 2003 R2 Enterprise x64 Edition.

The main problem is with connectiong to OWC11.
When i try to request the ChartSpaceClass I'm recieving the following error (Platform target: Any CPU):

Retrieving the COM class factory for component with CLSID {0002E55D-0000-0000-C000-000000000046} failed due to the following error: 80040154.

When i try to recompile my solution using Platform target: x86 I'm recieving following error:

Could not load file or assembly 'BA.Application.Utils' or one of its dependencies. An attempt was made to load a program with an incorrect format. (C:\inetpub\wwwroot\web.config line 132)
Source Error:
<httpModules>
    <add name="ScriptModule" type="Microsoft.Web.Services.ScriptModule"/>
    ...
</httpModules>

And when i try to recompile my solution using Platform target: x64 I'm recieving following error (compilation error):

Attempted to load a 64-bit assembly on a 32-bit platform. Use ReflectionOnlyLoad() instead of trying to load for reflection purposes.

Is ther any way to solve this problem? (Or can i specify to the web project compilation mode = x86 platform?)

Server Configuration:

• Windows Server 2003 R2 Enterprise x64 Edition
• Microsoft Office 2003 (11.5612.5606)
• Microsoft .NET Framework Version: 2.0.50727.42; ASP.NET Version: 2.0.50727.210
• Oracle Client 10g (x64 version)

Another strange thing, that when I run my solution thru Dev Server all is Ok with OWC. Except that i need to use Oracle Client x32 bit version.

And when i run my solution in IIS i need to use Oracle Client x64 bit version. And OWC doesn't work.

did you find a solution to this problem?

I'm having a similar issue with PivotTable. It returns "The query could not be processed: The data provider didn't supply any further error information."

I am able to compile, instantiate the PivotTable class but get the error above.

For you x86 compilation error you might need the x86 version the library which cause the invalid format error

No we did not find any solution.

In the result we are installed classic windows server... :(

We were able to solve our issues by:

1) recompiling to target x86 specifically

2) reinstall OWC (it could be corrupted)

3) install Ole Db Provider Driver for SSAS (9.0 for OWC10 - and comes with Feature Pack for SQL 2005). Note that even if the target server (where your cube is SQL 2008 or another version, the client Driver should match your OWC version). Like in our case, the cube is on a SQL 2008 server but the client still needed the Ole Db Driver 9.0 (for SQL 2005) since we used OWC 10.

If you have any questions feel free to contact me at http://ryangaraygay.com/blog in case I might be able to help you.

Hope this helps.