Issue with interop.excel and com objects on live server.

Question

0.00/5 (No votes)

See more:

Hi,

I have created a project which creates excel sheets from the data base using microsoft.interop.excel library and its com objects.
Everything works like charm on my localhost but when i deployed this project I didnt got any error neider the things worked for me. Even a try and catch block failed to generate the exception. somehow I managed to get this error:
"Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.". I ran through numerous links and I changed the dcom file settings and allowed full access to things and I allowed impersonate in my web config also. Stil I am having same issue. Where am I missing ? Here is the link I referred too :
http://forums.asp.net/t/1303594.aspx/1/10[^]. Please help. Any help wil be really appreciated and blessed. Plz. Thank you in advance.

Posted 4-Sep-12 21:47pm

Taresh Uppal

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

barneyman · Answer 1 · 2012-09-04T22:10:00

Solution 1

Use something like ProcMon[^] to try to work out where it's failing

Specifically, filter for the CLSID, the APPID and the interop/dll paths

Also, examine the event log (security, and system) for more details

DCOM security is a pain, the machine limits[^] sometimes obscure what you've set for a specific APP

Posted 4-Sep-12 22:10pm

barneyman

Comments

Taresh Uppal 5-Sep-12 5:01am

I am currently using mic interop library version 5.0 is it even compatible with server 2003 or do i need to use version 12.0.0.0

Taresh Uppal 5-Sep-12 6:28am

Now getting this error when I try to open the sheet using workbooks.open method
:
The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))