在查询分析器中: SET NOCOUNT ON EXEC MASTER..XP_CMDSHELL 'OSQL -L'获取当前可以访问的sql server,引用sqldmo。 Dim Server As SQLDMO.NameList Dim appDMO As New SQLDMO.Application Dim i As Integer
On Error GoTo Error
Set Server = appDMO.ListAvailableSQLServers
For i = 1 To Server.Count cmbServer.AddItem Server(i) 'Debug.Print Server(i) Next
SET NOCOUNT ON
EXEC MASTER..XP_CMDSHELL 'OSQL -L'获取当前可以访问的sql server,引用sqldmo。 Dim Server As SQLDMO.NameList
Dim appDMO As New SQLDMO.Application
Dim i As Integer
On Error GoTo Error
Set Server = appDMO.ListAvailableSQLServers
For i = 1 To Server.Count
cmbServer.AddItem Server(i)
'Debug.Print Server(i)
Next