找不到microsoft.sqlserver.batchparser.dll [英] Can't find microsoft.sqlserver.batchparser.dll

问题描述

我写它使用SMO对SQL Server 2008能够运行一些脚本DB一个asp.net web应用程序。它引用这些程序集（在C：\\ Program Files文件\\ Microsoft SQL Server的\\ 100 \\ SDK \\组件文件夹）：

I wrote an asp.net web app which uses SMO against SQL Server 2008 to be able to run some DB scripts. It references these assemblies (in the C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies folder):

Microsoft.SqlServer.ConnectionInfo
Microsoft.SqlServer.Management.Sdk.Sfc
Microsoft.SqlServer.Smo

该microsoft.sqlserver.batchparser.dll不在此文件夹中。
本地（32位机，IIS7）我没有问题。

The microsoft.sqlserver.batchparser.dll is not in this folder. Locally (32 bits machine, IIS7) I have no issue.

当我发布应用到我的托管服务提供商（discountasp.net，SQL Server 2008中，IIS7，32位也是如此），我得到这个错误：

When I publish the app to my hosting provider (discountasp.net, SQL Server 2008, IIS7, 32bits too), I get this error:

无法加载文件或程序
  Microsoft.SqlServer.BatchParser，
  版本= 10.0.0.0，文化=中立，
  公钥= 89845dcd8080cc91或
  它的一个依赖。系统
  无法找到指定的文件。

Could not load file or assembly 'Microsoft.SqlServer.BatchParser, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

我搜索我的本地机器，我无法找到该组件。然而，它的工作原理以及在此计算机上。

I searched my local machine and I can't find this assembly. However it works well on this machine.

我已经v10.1.2531.0本地安装在Microsoft SQL Server 2008安装发现报告工具报告。

The "Microsoft SQL Server 2008 Setup Discovery Report" tool reports I have v10.1.2531.0 installed locally.

感谢

推荐答案

要获得此DLL，您将需要从的这里）。这特定的DLL被安装到GAC，这就是为什么你可能无法使用搜索找到它。

To get this dll, you will need to install the Microsoft SQL Server 2008 Management Objects (available from here). That particular dll gets installed into the GAC, which is why you probably cannot find it using a search.

由于您使用的是托管服务提供商，它会出现，他们没有这个安装。您的选择是把它由安装它们（这可能是不太可能），或者手动部署DLL（这可能是狡猾的许可接地）。

As you are using a hosting provider, it would appear that they do not have this installed. Your choices are to get it installed by them (which is probably unlikely), or deploy the dll manually (which may be on dodgy licencing ground).

这篇关于找不到microsoft.sqlserver.batchparser.dll的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！