asked on

Production server can't find assembly.

Yesterday, I referenced a COM assembly on my development machine: Microsoft Excel 14.0 Object Library

The reference was to my GAC, on the suggestion of yv989c, I took the following steps.

1. I opened the properties for the Excel 14.0 reference (Microsoft.Office.Interop.Excel). Here, I set Embed Interops Types to FALSE and Local Copy to TRUE. (Image 1.)
2. I re-published the project, tested it locally (all was well), and deployed my project assembly, ParkAsset.dll, and Microsoft.Office.Interop.Excel.dll to the production server.
3. Despite taking these steps, I'm still seeing the following error on the production server.

Could not load file or assembly 'office, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

What step did I miss?
Image-1.png

ingriT

Isn't there a generic DLL, like Microsoft.Office.Interop, Microsoft.Office.Server or Microsoft.Office that the Microsoft.Office.Interop.Excel dll depends on?

ASKER CERTIFIED SOLUTION

Éric Moreau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Carlos Villegas

Hi, the MS Excel installed in your production server is 64bits? if not, are you web application pool set to enable 32bit applications?

jdana

ASKER

ingriT,
Isn't there a generic DLL, like Microsoft.Office.Interop, Microsoft.Office.Server or Microsoft.Office that the Microsoft.Office.Interop.Excel dll depends on?

All I've found are downloads for the specific PIAs.
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=938fe8ad-583b-4bd7-a345-23250dc15855

emoreau,
is Excel installed on your production Server?

This may be my missing link. Does Microsoft.Office.Interop.Excel.dll ride on top of a full Excel install? The more I think about it, the more that makes sense. Your thoughts?

yv989c,
Hi, the MS Excel installed in your production server is 64bits? if not, are you web application pool set to enable 32bit applications?

Thanks again for sticking with this thread. You've been terrific. Development machine and server are both 32-bits. We're good there.

SOLUTION

Éric Moreau

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Carlos Villegas

Hi, please, check this, Im not sure if it is your problem, because I never had problems with office interop, this guy choose not to install .net support in his Office 2010 installation and ended having your problem:
http://sqlblog.com/blogs/davide_mauri/archive/2010/07/30/powerpivot-not-visibile-in-excel.aspx

Carlos Villegas

In that post someone says:

This worked for me. Evidently .NET Progammability Support isn't installed by default.

jdana

ASKER

yv989c,

emoreau states that Excel must be installed on the server. It's not. Sounds like that's my issue. Your thoughts?

J

Carlos Villegas

Of course buddy... that is the problem... but I remember that you say that it was installed on the server... im wrong?? I will find that post...

Carlos Villegas

Buddy, I thought that was installed on the production server for this question that you asked:
https://www.experts-exchange.com/questions/26988247/How-do-I-reference-a-COM-library-with-the-IIS-server-or-ASP-server.html

I referenced the Microsoft Excel 14.0 Object Library for an ASP.NET project on my development machine, and the associated code works fine. After I install MS Excel 2010 on the production server, how do I reference the library?

Just install it, that will fix your problem!

Carlos Villegas

By the way, the credits here are for emoreau

jdana

ASKER

emoreau,

Thanks for your help.