SQL-DMO ListAvailableServers with ASP.NET

Question

Post reply

SQL-DMO ListAvailableServers with ASP.NET

wbeetge

SSChasing Mays

Points: 636
More actions
May 27, 2004 at 10:02 pm

#102041

I have tried to adapt my VB6 code for DMO to list the servers on our network.
It fails when it hits the listavailableservers method with:
   QueryInterface for interface SQLDMO.NameList failed.
This is my code:
Dim i As Integer
Dim oSQLApp As SQLDMO.Application
Dim oNames As SQLDMO.NameList
   oSQLApp =
New SQLDMO.Application()
   oNames = oSQLApp.ListAvailableSQLServers()
   cmbServers.Items.Clear()
   For i = 1 To oNames.Count
      cmbServers.Items.Add(oNames.Item(i).ToString)
   Next i
Any ideas please ???

Graham
May 31, 2004 at 8:00 am

This was removed by the editor as SPAM

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Chiara SSC Veteran Points: 212 More actions · Answer 1

Did you see this?

http://www.codeproject.com/useritems/listsqlservers.asp?df=100&forumid=3432&exp=0&select=508182

or

http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?txtCodeId=734&lngWId=10

Ciao, Chiara

wbeetge SSChasing Mays Points: 636 More actions · Answer 2

Hi Chiara.

Thanks for your reply

In the end I did the same as the first example. I took my class vrom VB6 and compiled it into a dll. I just would have liked a .NET solution more rather than using COM.