无法在生产ASP.net站点上加载文件或程序集Microsoft.SqlServer.SqlClrProvider，它在哪里? [英] Could not load file or assembly Microsoft.SqlServer.SqlClrProvider on production ASP.net site, where is it?

问题描述

在我的ASP.net网站上，有对 Microsoft.SQLserver.SMO 的引用.我将此引用复制到生产服务器上，并出现 Microsoft.SqlServer.Management.Sdk.Sfc 的无法加载错误.通过从

On my ASP.net site I have a reference to Microsoft.SQLserver.SMO. I copied this reference onto my production server and got a could not load error for Microsoft.SqlServer.Management.Sdk.Sfc. This error was fixed by copying the dll from the

C:\Program files\Microsoft Sql Server\110\SDK\Assembilies

但是我后来又遇到了相同的错误，但找不到的是 Microsoft.SqlServer.SqlClrProvider .

However I then got the same error but for Microsoft.SqlServer.SqlClrProvider which is nowhere to be found.

在哪里可以找到 SqlClrProvider dll?它可以在我的本地主机上运行，​​因此必须在某个地方.

Where can I find the SqlClrProvider dll? It works on my localhost so it must be somewhere.

推荐答案

在您的开发计算机或安装了SQL Server的计算机上， Microsoft.SqlServer.SqlClrProvider.dll 文件位于您的计算机中. GAC .但是，如果不对注册表进行更改，则无法复制此文件.

On your development machine or a machine where you have SQL Server installed, the Microsoft.SqlServer.SqlClrProvider.dll file is in your GAC. However, you cannot copy this file without making changes to the registry.

使用注册表编辑器，转到 HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Fusion .添加一个名为 DisableCacheViewer 的新 DWORD .给它一个 1 的值.

Using the registry editor, go to HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Fusion. Add a new DWORD called DisableCacheViewer. Give it a value of 1.

进行此更改后，您可以转到C:\ Windows \ assembly \ GAC_MSIL \ Microsoft.SqlServer.SqlClrProvider \ 来获取所需的dll.

Once this change is made, you can go to C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.SqlClrProvider\ to get the dll you need.

要查看更详细的说明，请单击以下链接之一:

To see a more detailed explanation, follow one of these links:

• 无法加载文件或程序集Microsoft.SqlServer.SqlClrProvider

这篇关于无法在生产ASP.net站点上加载文件或程序集Microsoft.SqlServer.SqlClrProvider，它在哪里?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！