Problems with ListAvailableSQLServers (SQLDMO)

[Craig G]

i have the following code in a form load event, that (should) simply
populate a combobox with the names of all SQL servers on the network

Dim x As Long
Dim sqlNameList As SQLDMO.NameList

'Filling Servers Name

sqlNameList = sqlApp.ListAvai lableSQLServers

For x = 1 To sqlNameList.Cou nt

cbo_Server.Item s.Add(UCase(sql NameList.Item(x )))

Next


Me.Show()



but it falls over on the ListAvailableSe rvers, with the following error

"QueryInter face for interface SQLDMO.NameList failed."



im pretty new to this .net (vb6 previously) so i dont know what is wrong

any idea's??

Cheers,
Craig

[Patrick Steele [MVP]]

Re: Problems with ListAvailableSQ LServers (SQLDMO)

In article <etGzikLREHA.13 48@TK2MSFTNGP12 .phx.gbl>, Gambit001
@hotmail.com says...[color=blue]
> "QueryInter face for interface SQLDMO.NameList failed."[/color]

If you're running SQL2000, make sure SP2 is installed. This was a known
bug fixed in SP2.

--
Patrick Steele
Microsoft .NET MVP

http://weblogs.asp.net/psteele