enumerating MSDE servers in C# using SQLDMO
-
In Windows XP Home Edition, when trying to list MSDE servers using C# and SQLDMO the list is empty. For instance, when doing
SQLDMO.ApplicationClass DMOApp= new SQLDMO.ApplicationClass();
SQLDMO.NameList names=DMOApp.ListAvailableSQLServers();I get names.Count=0, although two instances of the MSDE server are installed. Can anybody help?
-
In Windows XP Home Edition, when trying to list MSDE servers using C# and SQLDMO the list is empty. For instance, when doing
SQLDMO.ApplicationClass DMOApp= new SQLDMO.ApplicationClass();
SQLDMO.NameList names=DMOApp.ListAvailableSQLServers();I get names.Count=0, although two instances of the MSDE server are installed. Can anybody help?
Hmm, SQLDMO only comes with SQL Server, not MSDE. leppie::AllocCPArticle(Generic DFA State Machine for .NET);
-
Hmm, SQLDMO only comes with SQL Server, not MSDE. leppie::AllocCPArticle(Generic DFA State Machine for .NET);
That is not true. You can add a reference to the Microsoft SQLDMO Object Library 8.0 in the COM tab of the Add Reference dialog in Visual Studio when you have MSDE installed. As an exemple, see this Christian Graus article. http://www.codeproject.com/cs/database/MSDE-GUI.asp[^]
-
That is not true. You can add a reference to the Microsoft SQLDMO Object Library 8.0 in the COM tab of the Add Reference dialog in Visual Studio when you have MSDE installed. As an exemple, see this Christian Graus article. http://www.codeproject.com/cs/database/MSDE-GUI.asp[^]
-
I wish that people would not reply if they are not 100% sure. I was just reading a book about that and also people have made apps that lets people administer these MSDE applications thru the SQLDMO library.
Im so sorry boo hooh hoo leppie::AllocCPArticle(Generic DFA State Machine for .NET);