'引入 SQLDMO 库 '搜索SQL Server服务器,并且枚举可以使用的合乎规则的数据库On Error GoTo errEnum Dim oApplication As New SQLDMO.Application Dim oSQLServerGroup As SQLDMO.ServerGroup Dim oRegisteredServer As SQLDMO.RegisteredServer Dim oSQLServer As New SQLDMO.SQLServer Dim oDatabase As SQLDMO.Database
'枚举SQL Server服务器 For Each oSQLServerGroup In oApplication.ServerGroups For Each oRegisteredServer In oSQLServerGroup.RegisteredServers CmbServer.AddItem oRegisteredServer.Name Next Next
If CmbServer.ListCount = 0 Then CmbServer.AddItem "192.168.0.1" End If
For Each oDatabase In oSQLServer.Databases If InStr(1, oDatabase.Name, "DB") <> 0 Then CmbDatabase.AddItem Right(oDatabase.Name, 4) & "年数据库" End If Next
If CmbDatabase.ListCount = 0 Then CmbDatabase.AddItem "没有可选数据库" End If
CmbDatabase.Text = CmbDatabase.List(0)
Exit Sub
errEnum: CmbServer.Clear CmbDatabase.Clear MsgBox Err.Description Exit Sub
'搜索SQL Server服务器,并且枚举可以使用的合乎规则的数据库On Error GoTo errEnum Dim oApplication As New SQLDMO.Application
Dim oSQLServerGroup As SQLDMO.ServerGroup
Dim oRegisteredServer As SQLDMO.RegisteredServer
Dim oSQLServer As New SQLDMO.SQLServer
Dim oDatabase As SQLDMO.Database
'枚举SQL Server服务器
For Each oSQLServerGroup In oApplication.ServerGroups
For Each oRegisteredServer In oSQLServerGroup.RegisteredServers
CmbServer.AddItem oRegisteredServer.Name
Next
Next
If CmbServer.ListCount = 0 Then
CmbServer.AddItem "192.168.0.1"
End If
CmbServer.Text = CmbServer.List(0)
'枚举缺省的数据库
'先连接
oSQLServer.Connect CmbServer.Text, "sa", "password"
For Each oDatabase In oSQLServer.Databases
If InStr(1, oDatabase.Name, "DB") <> 0 Then
CmbDatabase.AddItem Right(oDatabase.Name, 4) & "年数据库"
End If
Next
If CmbDatabase.ListCount = 0 Then
CmbDatabase.AddItem "没有可选数据库"
End If
CmbDatabase.Text = CmbDatabase.List(0)
Exit Sub
errEnum:
CmbServer.Clear
CmbDatabase.Clear
MsgBox Err.Description
Exit Sub
打不开,可能因为防盗链功能。
'SQL帮助里面有详细 介绍 和 实例(还是vb的)。
'SQLDMO。dll不能在98下注册。