安装 MS SQL Server server/client 引用 Microsoft SQLDMO Object Library'下面是代码 Option ExplicitPrivate Sub Command1_Click() On Error GoTo Err1 Dim dmoObj As New SQLDMO.Application Dim I As Long
For I = 1 To dmoObj.ListAvailableSQLServers.Count List1.AddItem dmoObj.ListAvailableSQLServers.Item(I) Next Err1: End Sub
引用 Microsoft SQLDMO Object Library'下面是代码
Option ExplicitPrivate Sub Command1_Click()
On Error GoTo Err1
Dim dmoObj As New SQLDMO.Application
Dim I As Long
For I = 1 To dmoObj.ListAvailableSQLServers.Count
List1.AddItem dmoObj.ListAvailableSQLServers.Item(I)
Next
Err1:
End Sub