Hi.
I found some info on the C# forums but my problem is a bit different.
http://vbforums.com/showthread.php?t=459135
Im using the following code to get a list of servers on our network:
I get no errors when running this code, but the results differ; no servers found, (local) and servers on other machines.Code:Dim sqlApp As New SQLDMO.Application Dim sqlServers As SQLDMO.NameList = sqlApp.ListAvailableSQLServers For Each srv As String In sqlServers If srv <> Nothing Then Me.ListBox1.Items.Add(srv) End If Next
Does anyone have any idea why this happens?
The other computers in the network have both 2000/2005 MSSQL.
My local MSSQL is 2005 Dev.
Thanks,
Torbis




Reply With Quote