blocks|key|3229727|text|若要获取此dll，您需要安装Microsoft+SQL+Server+2008管理对象(可从here获得)。这个特定的dll被安装到GAC中，这就是为什么您可能无法使用搜索找到它的原因。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3229728|由于您使用的是主机提供商，因此看起来他们没有安装此程序。您的选择是由他们安装它(这可能是不太可能的)，或者手动部署dll+(这可能是在不可靠的许可基础上)。|3229729|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=16978#SMO^0|1A|4|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

To get this dll, you will need to install the Microsoft SQL Server 2008 Management Objects (available from <a href="http://www.microsoft.com/en-us/download/details.aspx?id=16978#SMO" rel="noreferrer">here</a>). That particular dll gets installed into the GAC, which is why you probably cannot find it using a search.

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).

blocks|key|291181|text|您还需要在您的主机提供商上安装SMO组件。你可以下载他们的here。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|291182|entityMap|0|LINK|mutability|MUTABLE|url|http://go.microsoft.com/fwlink/?LinkId=123708&clcid=0x409^0|T|4|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

You need to have the SMO components installed on your hosting provider as well. You can download them <a href="http://go.microsoft.com/fwlink/?LinkId=123708&amp;clcid=0x409" rel="nofollow">here</a>.

blocks|key|3015575|text|我也遇到过类似的问题，但用的是R2。对我来说，它是通过为SQL+Server®2008+R2安装Microsoft®SQL+Server®2008+R2共享管理对象和相关的Microsoft®System+CLR类型来实现的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3015576|在这里找到它们http://www.microsoft.com/en-us/download/confirmation.aspx?id=16978|offset|length|3015577|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/confirmation.aspx?id=16978^0|0|7|1U|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

I had a similar issue, but with R2. For me it worked by installing Microsoft® SQL Server® 2008 R2 Shared Management Objects and dependant Microsoft® System CLR Types for SQL Server® 2008 R2.

Find them here <a href="http://www.microsoft.com/en-us/download/confirmation.aspx?id=16978" rel="nofollow">http://www.microsoft.com/en-us/download/confirmation.aspx?id=16978</a>

blocks|key|294290|text|首先你需要开启GAC文件夹的浏览功能：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|294291|294292|转到注册表编辑器(运行>regedit)|ordered-list-item|294293|转到HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion|294294|Right单击融合>新建>DWORD值类型DisableCacheViewer|294295|Double单击DisableCacheViewer|294296|Set+|294297|+to+1|294298|+to+1|294299|294300|然后你可以在这里找到它|294301|C:\Windows\assembly\GAC_32\Microsoft.SqlServer.BatchParser\10.0.0.0__89845dcd8080cc91|294302|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|11|8|@]|9|@]|A|$]]|$1|H|3|I|5|E|7|12|8|@]|9|@]|A|$]]|$1|J|3|K|5|E|7|13|8|@]|9|@]|A|$]]|$1|L|3|M|5|E|7|14|8|@]|9|@]|A|$]]|$1|N|3|O|5|E|7|15|8|@]|9|@]|A|$]]|$1|P|3|Q|5|E|7|16|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|18|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|19|8|@]|9|@]|A|$]]|$1|W|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|X|$]]

First you need to enable browsing of GAC folder:
 
 1. go to Registry Editor (RUN > regedit) 
 2. go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Fusion 
 3. Right click Fusion > NEW > DWORD 
 4. Type DisableCacheViewer 
 5. Double click DisableCacheViewer 
 6. Set value to 1 
 
then you can find it here
 
C:\Windows\assembly\GAC_32\Microsoft.SqlServer.BatchParser\10.0.0.0__89845dcd8080cc91

blocks|key|293521|text|您也可以从SQL+Server+DVD安装SQL客户端连接功能。在安装SolarWinds时，我安装了它和SDK组件来解决这个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|293522|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

You could install the SQL Client Connection feature from the SQL Server DVD as well. I installed that as well as the SDK components to resolve this issue while installing SolarWinds.

blocks|key|294306|text|我安装了SMO+x64，但构建服务器上需要SMO+x86。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|294307|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I had SMO x64 installed, but SMO x86 was required on build server.

blocks|key|296233|text|我只是解决了这个问题单击项目导航到属性并将平台目标从'Any‘更改为'x86’|type|unstyled|depth|inlineStyleRanges|entityRanges|data|296234|​|296235|📷|atomic|offset|length|296236|296237|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/64a2540357e79567ad8ac4c3380d844c.png|imageAlt^0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|T|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@$G|V|H|W|1|X]]|A|$]]|$1|I|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Z|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q|R|-4]]]]

I resolve this only Just Right Click on Project navigate to Properties and Change Platform Target from 'Any' to 'x86'

<a href="https://i.stack.imgur.com/h8Ccb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h8Ccb.png" alt="failed to load microsoft.sqlserver.batchparser"></a>

blocks|key|294328|text|+<startup+useLegacyV2RuntimeActivationPolicy="true">+in+App.config|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|294329|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code> &lt;startup useLegacyV2RuntimeActivationPolicy=&quot;true&quot;&gt; in App.config
</code></pre>

blocks|key|293549|text|这件事今天发生在我身上。以管理员身份运行可以帮我解决这个问题，我不知道为什么。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|293550|它在生产环境中不是很理想，但在开发环境中可能正好适用。|293551|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

This happened to me today. Running as administrator did the trick for me, I'm not sure why.
It's not ideal for production, but might work just fin for development environments.

blocks|key|3015690|text|如果“Microsoft+Visual+C%2B%2B+2013+Redistributable+(X86)”未显示在“添加/删除程序”中，请安装它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3015691|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Install the 'Microsoft Visual C++ 2013 Redistributable (x86)' if it is not showing up in add/remove programs.

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):

<pre><code>Microsoft.SqlServer.ConnectionInfo
Microsoft.SqlServer.Management.Sdk.Sfc
Microsoft.SqlServer.Smo
</code></pre>

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

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

<blockquote>
 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.
</blockquote>

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

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

Can't find microsoft.sqlserver.batchparser.dll

SQL Server

数据库

服务器

Windows

我写了一个asp.net web应用程序，它使用SMO来对抗SQL Server2008，以便能够运行一些数据库脚本。它引用以下程序集(位于C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies文件夹中)：Microsoft.SqlServer.Connecti...

问找不到microsoft.sqlserver.batchparser.dll
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问找不到microsoft.sqlserver.batchparser.dllEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问找不到microsoft.sqlserver.batchparser.dll
EN