在sql中
master数据库中有
select * from sysdatabases where name = '数据库名'
master数据库中有
select * from sysdatabases where name = '数据库名'
解决方案 »
- SecureCRT.EXe执行脚本后,怎么将获取的信息过滤
- vb(Client)+Java(Server)端WebService数据传输的加密和解密问题如何处理那?
- 如何在程序中获得ODBC中的路径?
- 搞不定COMMAND啦,各位帮帮忙吧!
- 求助,SQL语句创建access表时,字段类型如何定义?
- 我的窗体一最大化,窗体上的控件的位置,停留在原来的位置上.怎能随着最大化而使控件的位置也跟着变.
- 关于ACCESS数据库的问题
- 求助VB添加数据库问题
- vb关于图片分割的边界问题,利用StretchBlt函数将原图一块块的复制到图片框choosepicbox。
- 难题!关于大文件分盘拷贝的问题 请高手们多多帮忙
- 100分
- vb连上数据库之后的一些操作问题想请教大家:)
那么在你的工程中引入:microsoft sqldmo object library
然后:
Dim s As SQLDMO.SQLServer
Set s = New SQLDMO.SQLServer
'connect to the valiad server
s.Connect 服务器名, "sa", ""
If Err <> 0 Then
MsgBox "error"
Exit Sub
End If
For i = 1 To s.Databases.Count
'这里可以获得这个服务器中的所有数据库名,
if s.Databases(i).Name="water" then
'你自己处理了
End if
Next
'Add the Reference of "microsoft SQLDMO Object Library"
'Add a ComboBox On the Form,named cboServer
'Add a Checkbox On the Form,named chkNTSecurity
'Add two textbox On the Form,named txtUID,txtPWD
'Add a CommandBox On the Form,named cmdConnect
'Add a textbox On the Form,named txtDatabase(the Database you want to check whether exist)
'Add a CommandBox On the Form,named cmdCheck
'This Program is to Show How to Use SQLDMO to Check a Database whether ExistDim oSQLServer As New SQLDMO.SQLServerPrivate Sub cboServer_Change()
cmdConnect.Enabled = True
End SubPrivate Sub chkNTSecurity_Click() If chkNTSecurity.Value = vbChecked Then
txtUID.Enabled = False
txtPWD.Enabled = False
End If
End SubPrivate Sub cmdCheck_Click()
' lstDatabases.Text = txtDataBase.Text
' If lstDatabases.ListIndex <> -1 Then
' MsgBox "The DataBase is Exist!"
' Else
' MsgBox "The DataBase isn't Exist!"
' End If
Dim oDatabase As SQLDMO.Database
On Error GoTo CheckError
' Check the databases whether exist
For Each oDatabase In oSQLServer.Databases
If oDatabase.Status <> SQLDMODBStat_Inaccessible Then
'
If UCase(txtDatabase.Text) = UCase(oDatabase.Name) Then
MsgBox "The Database You want to check is exist!"
Exit Sub
End If
End If
Next oDatabase
MsgBox "The Database You want to check isn't exist!"
Exit Sub
CheckError:
SQLDMOError
End SubPrivate Sub cmdConnect_Click() On Error GoTo ConnectError
MousePointer = vbHourglass
' Setup a secure login for NT security
If chkNTSecurity.Value = vbChecked Then
oSQLServer.LoginSecure = True
End If
' Connect to the selected SQL Server system
oSQLServer.Connect cboServer.Text, txtUID.Text, txtPWD.Text
'Disabled the Connect Button
cmdConnect.Enabled = False
MousePointer = vbDefault
Exit Sub
ConnectError:
SQLDMOError
MousePointer = vbDefault
End SubPrivate Sub Form_Load() Dim oApplication As New SQLDMO.Application
Dim oServerGroup As SQLDMO.ServerGroup
Dim oRegisteredServer As SQLDMO.RegisteredServer
cboServer.Clear
' Process all the server groups
For Each oServerGroup In oApplication.ServerGroups
' Process each registered server
For Each oRegisteredServer In oServerGroup.RegisteredServers
' Add each name to the combobox
cboServer.AddItem oRegisteredServer.Name
Next
Next
Set oRegisteredServer = Nothing
Set oServerGroup = Nothing
Set oApplication = Nothing
End SubPublic Function SQLDMOError()
Dim sErrorMsg As String
sErrorMsg = Err.Source & " Error: " & _
Err.Number - vbObjectError & ": " & Err.Description SQLDMOError = MsgBox(sErrorMsg, vbOKOnly, "SQL-DMO Error")End Function
Private Sub cboServer_Click()
cmdConnect.Enabled = True
End Sub
如成功会提示测试成功!!
' 函数名:ExistTable
' 函数说明:判断数据库中是否有特定的表
' 参数:TableName,Cn
' 参数说明:
' TableName:要判断的表名
' Cn:连接名
' 返回值:有
' 返回值说明:1.存在;0,不存在
' 作者:李梓钰.
' 注意事项:无.
' 创建日期:2002/01/05
' 修改日期:2002/01/05
'-------------------------------------------------
Public Function ExistTable(TableName, Cn As ADODB.Connection) As String
Dim i As Integer
Dim Rs_ExitTable As New ADODB.Recordset
Dim Cn_ExitTable As New ADODB.Connection
On Error GoTo FindErr:
Set Cn_ExitTable = Cn
Cn_ExitTable.CursorLocation = adUseClient
Set Rs_ExitTable = Cn_ExitTable.OpenSchema(adSchemaTables) For i = 0 To Rs_ExitTable.RecordCount - 1
If Rs_ExitTable!table_name = TableName Then
ExistTable = 1
Exit For
Else
ExistTable = 0
End If
Rs_ExitTable.MoveNext
If Rs_ExitTable.EOF Then Rs_ExitTable.MoveLast
Next
Exit Function
FindErr:
MsgBox Err.Description
End Function
以上代码保存于: SourceCode Explorer(源代码数据库)
复制时间: 2002-11-02 21:18
软件版本: 1.0.746
软件作者: Shawls
个人主页: Http://Shawls.Yeah.Net
E-Mail: [email protected]
QQ: 9181729