Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
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 22:47pm

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

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
  Permalink  
Comments
Taresh Uppal at 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 at 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))

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



Advertise | Privacy | Mobile
Web03 | 2.8.1411022.1 | Last Updated 5 Sep 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100