winsck获得局域网的SQL Server列表
参考:SQLping程序
原理:利用1434端口,向其发送一个字节内容为02即可返回
代码:向窗口放一个button和一个winsock
Private Sub Command1_Click()
Dim aa As Byte
aa = &H2
Winsock1.SendData aa
End Sub
Private Sub Form_Load()
With Winsock1
.RemoteHost = "255.255.255.255"
.RemotePort = 1434
.Protocol = sckUDPProtocol
.Bind 2000
End With
End Sub
Private Sub Winsock1_DataArrival(ByVal bytesTotal As Long)
Dim mystr As String
Dim sValue
Winsock1.GetData mystr
sValue = Split(mystr, ";")
Debug.Print "主机地址:" & Winsock1.RemoteHostIP
Debug.Print "主机名称:" & sValue(1)
Debug.Print "名称:" & sValue(3)
Debug.Print "是否集群:" & sValue(5)
Debug.Print "版本:" & sValue(7)
Debug.Print "TCP端口:" & sValue(9)
End Sub
请有条件的朋友测试一下,效果是与DMOSQL一致?