[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1917
  • Last Modified:

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
0
jdana
Asked:
jdana
  • 6
  • 3
  • 2
  • +1
2 Solutions
 
ingriTCommented:
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?

0
 
Éric MoreauSenior .Net ConsultantCommented:
is Excel installed on your production Server?
0
 
Carlos VillegasFull Stack .NET DeveloperCommented:
Hi, the MS Excel installed in your production server is 64bits? if not, are you web application pool set to enable 32bit applications?
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
jdanaAuthor Commented:
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.
0
 
Éric MoreauSenior .Net ConsultantCommented:
>>This may be my missing link.  Does Microsoft.Office.Interop.Excel.dll ride on top of a full Excel install?

yes

this is why I use components like http://www.aspose.com/categories/.net-components/aspose.cells-for-.net/default.aspx instead of installing Excel on a server
0
 
Carlos VillegasFull Stack .NET DeveloperCommented:
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
0
 
Carlos VillegasFull Stack .NET DeveloperCommented:
In that post someone says:
This worked for me. Evidently .NET Progammability Support isn't installed by default.
0
 
jdanaAuthor Commented:
yv989c,

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

J
0
 
Carlos VillegasFull Stack .NET DeveloperCommented:
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...
0
 
Carlos VillegasFull Stack .NET DeveloperCommented:
Buddy, I thought that was installed on the production server for this question that you asked:
http://www.experts-exchange.com/Programming/Languages/.NET/ASP.NET/Q_26988247.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!
0
 
Carlos VillegasFull Stack .NET DeveloperCommented:
By the way, the credits here are for emoreau
0
 
jdanaAuthor Commented:
emoreau,

Thanks for your help.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 6
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now