实时服务器上的interop.excel和com对象出现问题. [英] Issue with interop.excel and com objects on live server.

问题描述

我创建了一个项目，该项目使用microsoft.interop.excel库及其com对象从数据库创建excel表.
一切在我的本地主机上都像魅力一样工作，但是当我部署该项目时，我没有遇到任何错误，这一切对我来说都是有效的.即使try and catch块也未能生成异常.我以某种方式设法得到此错误:
由于以下错误，为具有CLSID {00024500-0000-0000-C000-000000000046}的组件检索COM类工厂失败，因为以下错误:80070005.".我浏览了许多链接，并更改了dcom文件设置，并允许完全访问内容，并且还允许在我的Web配置中模拟. Stil我有同样的问题.我在哪里想念?这也是我引用的链接:
http://forums.asp.net/t/1303594.aspx/1/10 [ ^ ].请帮忙.任何帮助都会得到真正的赞赏和祝福. Plz.预先谢谢您.

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.

推荐答案

使用类似 ProcMon [^ ]尝试找出失败的地方

具体来说，请过滤CLSID，APPID和interop/dll路径

另外，请查看事件日志(安全性和系统)以获取更多详细信息

DCOM安全令人痛苦，计算机限制 [ ^ ]有时会掩盖什么您已经为特定的APP设置了

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

这篇关于实时服务器上的interop.excel和com对象出现问题.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！