首页 > Linux操作系统 > Linux操作系统 > 如何自动发布MS SQL SERVER数据库(转)

如何自动发布MS SQL SERVER数据库(转)

原创 Linux操作系统 作者:jcszjswkzhou 时间:2019-03-13 18:12:05 0 删除 编辑


Option Explicit

’define the sql connect
Dim oSQLServer As SQLDMO.SQLServer
Dim oCurrentDB As SQLDMO.Database
Dim oCurrentTable As SQLDMO.Table
Dim oTestIdx As SQLDMO.Index

sqlDmo is Connected Yes or No
Public sName As String
Private IsConnected As Boolean

’connect to local database server
Public Function ConnectDmo() As Boolean
On Error GoTo HandleError
’If we’re connected, then disconnect and clear lists.
If IsConnected = True Then
IsConnected = False
End If
’Begin connect to sqlserver or msde
’Attempt a connection, then fill the properties stuff.
oSQLServer.ApplicationName = "SQL-DMO Index Test"
oSQLServer.LoginSecure = True

oSQLServer.Connect "(local)", "sa", ""

IsConnected = True
ConnectDmo = True

’connect failth
If IsConnected = False Then
IsConnected = False
ConnectDmo = False
End If

End Function

’add a exists database to server
Public Function AddDataBase(ByVal dbName As String, ByVal DBPath As String, ByVal rstr As String) As Boolean
Dim rstring
’rstring = oSQLServer.AttachDBWithSingleFile(dbName, DBPath)
rstring = oSQLServer.AttachDB(dbName, DBPath)
AddDataBase = True

rstr = rstring
End Function

’delete the exists database
Public Function DelDataBase(ByVal dbName As String) As Boolean
Dim rstring
rstring = oSQLServer.DetachDB(dbName)
DelDataBase = True
End Function

Private Sub UserControl_Initialize()
On Error GoTo merror
Set oSQLServer = New SQLDMO.SQLServer
oSQLServer.LoginTimeout = 15
oSQLServer.ODBCPrefix = False
Name = "msdeconn1"
End Sub

Public Function isDBexists(ByVal dbName As String) As Boolean
Dim oDB As SQLDMO.Database
Dim rc As Boolean
’reconnect to database

rc = False
For Each oDB In oSQLServer.Databases
If oDB.SystemObject = False Then
If Trim(UCase(oDB.Name)) = Trim(UCase(dbName)) Then
rc = True
End If
End If
Next oDB

’set the return value
isDBexists = rc

End Function

Private Sub UserControl_Terminate()
’end connect the database
End Sub

Public Function startServer()
oSQLServer.Start True
End Function

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量