无法在服务器上加载所需的程序集 - Office 2010 主互操作
在 SSIS 中构建了一个引用 Microsoft.Office.Interop.Excel Ver 14 的 C# 脚本组件。在我的笔记本电脑上运行良好。 现在我需要在 Win 2008 R2 服务器上运行它,但该程序集不存在。
我从以下位置下载了 PIARedist.exe 版本:14.0.4763.1024: http://www .microsoft.com/download/en/details.aspx?id=3508
解压后,我通过双击运行了 o2010pia.msi。它开始运行并突然结束,但没有错误。
在自述文件中,它显示了安装的程序集是什么,但它们都没有显示在 GAC 中。我使用属于本地管理员组的帐户运行此操作。没有重启。
寻找建议。 - 谢谢
Built a C# Script Component in SSIS referencing Microsoft.Office.Interop.Excel Ver 14. Works fine on my laptop.
Now I need to run it on a Win 2008 R2 Server and that assembly does not exist.
I downloaded PIARedist.exe Version:14.0.4763.1024 from: http://www.microsoft.com/download/en/details.aspx?id=3508
After extracting I ran the o2010pia.msi by double clicking. It started to run and appeared to end abruptly but without errors.
In the readme it showed what the installed assemblies would be but none of them show in the GAC. I ran this using an account that is part of the local Admin group. Didn't reboot.
Looking for a suggestion. - thanks
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
我有同样的问题。
查看您所说的下载链接中的系统要求,我们可以看到没有提到Windows Server 2008 R2...并且可能不支持它。
》系统要求
支持的操作系统: Windows 2000 Service Pack 4、Windows Server 2003、Windows XP Service Pack 2
Microsoft Windows XP、Microsoft Windows Vista、Microsoft Windows Server 2003、Microsoft Windows Server 2008、Microsoft Windows 7
还需要以下各项:
Microsoft .NET Framework 2.0 或更高版本”
I am having the same issue.
Looking at the system requeriments in the download link you said, we can see that Windows Server 2008 R2 is not mentioned... And it may not be supported.
"System requirements
Supported operating systems: Windows 2000 Service Pack 4, Windows Server 2003, Windows XP Service Pack 2
Microsoft Windows XP, Microsoft Windows Vista, Microsoft Windows Server 2003, Microsoft Windows Server 2008, Microsoft Windows 7
The following is also required:
Microsoft .NET Framework 2.0 or higher"
我刚刚遇到了同样的问题,并通过以管理员身份运行命令提示符并运行:
msiexec /i o2010pia.msi
解决了它I just had the same issue and solved it by running command prompt as admin and running:
msiexec /i o2010pia.msi
我在 Windows 2008 R2 x64 服务器上遇到了类似的问题,其中 o2010pia.msi 安装程序似乎在安装过程中退出。我什至通过以管理员身份运行命令提示符然后执行“msiexec /i o2010pia.msi”来尝试cnyborg的答案。
无论如何,我部署了 ASP.NET Webforms 应用程序,并且在执行以下代码期间:
我收到了错误:
我尝试加载 .dot、.dotx 和 .docx 文件,但收到相同的错误消息。
经过一番拉扯和谷歌搜索后,我找到了一个解决非特定问题的人,但它解决了我的问题!
解决方案如下:
Windows 2008 R2 x64 Server
创建 C:\Windows\SysWOW64\config\systemprofile\Desktop 目录。
Windows 2008 R2 x86 服务器
创建 C:\Windows\System32\config\systemprofile\Desktop 目录。
完毕!
I was having a similar issue on a Windows 2008 R2 x64 server where the o2010pia.msi installer seems to quit during the installation. I even tried cnyborg's answer by running a command prompt as admin and then executing "msiexec /i o2010pia.msi".
I deployed my ASP.NET webforms application anyways and during execution of the following code:
I received the error:
I tried loading a .dot, .dotx, and .docx file but received the same error message.
After much hair pulling and Googling I found someone with a solution to a unspecific issue but it resolved my problem!
Here is the solution:
Windows 2008 R2 x64 Server
Create the C:\Windows\SysWOW64\config\systemprofile\Desktop directory.
Windows 2008 R2 x86 Server
Create the C:\Windows\System32\config\systemprofile\Desktop directory.
DONE!