Click here to Skip to main content
12,999,628 members (61,395 online)
Rate this:
Please Sign up or sign in to vote.

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 :[^]. Please help. Any help wil be really appreciated and blessed. Plz. Thank you in advance.
Posted 4-Sep-12 21:47pm

1 solution

Rate this: bad
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
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
Taresh Uppal 5-Sep-12 6:28am
Now getting this error when I try to open the sheet using 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170624.1 | Last Updated 5 Sep 2012
Copyright © CodeProject, 1999-2017
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