SQL Server枚举怀疑 [英] SQL Server Enumeration doubt

问题描述

我对SQL DMO表示怀疑，因为我目前正在使用该函数来枚举本地网络上SQL Server的列表.现在的问题是，Microsoft在MSDN上提到，将删除SQL Server 2008 R2之后的DMO，之后将仅支持SMO.

令人担忧的事实是:

1.我的应用程序是使用纯非托管代码在MFC中编写的
2. SMO似乎仅基于.NET.

是否有一种变通办法来获取网络上的SQL Server列表，而不必担心SQL DMO dll是否存在非托管代码，或者复制dll是唯一的解决方案?

道歉，如果以前曾问过这个问题，或者这是一个愚蠢的问题.如果以前已经回答过此问题，请您指导我，我们将不胜感激.谢谢！

I''ve got a doubt in SQL DMO as I''m currently using a function call from that to enumerate the list of SQL Servers on my local network. Now the problem is that Microsoft has mentioned on MSDN that DMO will be removed beyond SQL Server 2008 R2 following which only SMO will be supported.

The worrying fact about this is:

1. My application is written in MFC using pure unmanaged code
2. SMO looks to be only .NET based

Is there a workaround to get the list of SQL Servers on the network without worrying about the SQL DMO dll for unmanaged code or is copying the dll the only solution?

Apologies if this has been asked before or if it is a silly question. If this has already been answered before, I would appreciate it if you could direct me. Thanks!

推荐答案

检查在C#中枚举SQL Server实例，使用ODBC [ ^ ]，它是c#，但是会给您一些提示.

Check Enumerate SQL Server Instances in C#, Using ODBC[^], it is c#, but it gives you some hints.

这篇关于SQL Server枚举怀疑的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！