参考Microsoft.SqlServer.Smo.dll [英] Reference Microsoft.SqlServer.Smo.dll
问题描述
我需要使用<一个href="http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.server.aspx">Server存储在Microsoft.SqlServer.Smo.dll类我没有看到这个组件通常引用对话框。我发现它在C：/ Program Files文件/微软SQL服务器/ 100 / SDK /组件，并试图引用从那里，但Visual Studio中抛出一个错误参考C：/ Program Files文件/微软SQL服务器/ 100 / SDK /组件/ Microsoft.SqlServer.Smo.dll不能添加。请确保该文件是可访问的，并且它是一个有效的程序集或COM组件。我究竟做错了什么？
I need to use Server class which is stored in Microsoft.SqlServer.Smo.dll I don't see this assembly in usual References dialog. I have found it at C:/Program Files/Microsoft SQL Server/100/SDK/Assemblies and try to reference from there but Visual Studio throws an error "A reference 'C:/Program Files/Microsoft SQL Server/100/SDK/Assemblies/Microsoft.SqlServer.Smo.dll' could not be added. Please make sure that file is accessible, and that it is a valid assembly or COM component". What am I doing wrong?
推荐答案
C：\ Program Files文件\ Microsoft SQL Server的\ 100 \ SDK \组件是正确的文件夹位置（或 C：\ Program Files文件（x86）的\ Microsoft SQL Server的\ 100 \ SDK \组件在64位系统）。
C:\Program Files\Microsoft SQL Server\100\SDK\Assemblies is the correct folder location (or C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies on 64-bit systems).
您需要将引用添加到：
-
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.ConnectionInfo.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.Smo.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.Management.Sdk.Sfc.dll
Microsoft.SqlServer.SqlEnum.dll
Microsoft.SqlServer.SqlEnum.dll
（这是建设一个SMO应用程序所需的最小文件）
(These are the minimum files that are required to build an SMO application)
请参考：如何创建一个Visual C＃SMO项目Visual Studio .NET中
SQL Server管理对象（SMO）是可下载的相关 SQL Server的一部分（20XX）功能包（检查SmallPrint的，因为我不相信这是可再发行？）
The SQL Server Management Objects (SMO) are downloadable as part of the relevant SQL Server (20XX) Feature Pack (check the smallprint as I don't believe these are redistributable?)
这篇关于参考Microsoft.SqlServer.Smo.dll的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
