[x]
Posted via EE Mobile

Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.
Question
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!
8.0

DCOM-Server Side Excel

Asked by MattMa01 in Microsoft Excel Spreadsheet Software, Microsoft IIS Web Server, Active Server Pages (ASP)

Tags: DCOM, excel

I have an asp.net 2 application that uses MS excel 2003 on the server running window server 2003. I have recently become aware that this is not a wise move but in the short term this is our lot. The application has been running fine until it recently started having problems launching the excel. There was no apparent event that triggered the change. It now returns the error

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

A search of the net and Expert Exchange returned a variety of things to consider, primarily around the launch and access permission in the DCOM security tab. I tried a large number of things to get this to work including

i) ensuring that network service account has local launch permissions+using 'invoking user' identity (c.f ccrowe blog entry on the x80070005 error)
ii) running IIS 6 under the local system account
iii) running in IIS5 isolation mode
iv) reinstalling excel and ensuring nothing in the installation is set to be installed on first use
v) reboot etc

All with no luck. However we did stumble across a work around (which is very unsatisfactory) whereby if the DCOM identity is set to 'this user' and that user remains logged on then it works. This seems to be something equivalent to 'interactive user' being selected.

Any suggestions on what might be causing this or additional tests that might help isolate the issue would greatly appreciated as what little hair I have lives in fear!

Any suggestions greatly appreciated.

Matt

[+][-]05/10/09 04:48 PM, ID: 24350532Accepted Solution

View this solution now by starting your 30-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

About this solution

Zones: Microsoft Excel Spreadsheet Software, Microsoft IIS Web Server, Active Server Pages (ASP)
Tags: DCOM, excel
Sign Up Now!
Solution Provided By: MattMa01
Participating Experts: 1
Solution Grade: A
 
[+][-]05/10/09 09:39 AM, ID: 24348936Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05/11/09 01:18 PM, ID: 24358631Expert Comment

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 30-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20091111-EE-VQP-92 - Hierarchy / EE_QW_3_20080625