Public sDataType, sLoginServer, sLoginName, sZtServer, sZtDataName As String Public dbMainData As New ADODB.Connection Function OpenDatabase(db As ADODB.Connection, ByVal cDataType As String, ByVal cServer As String, ByVal cDataName As String) As Boolean On Error GoTo ErrHandle:
Dim cDataConnectString As String Select Case UCase(cDataType) Case "SQL" cDataConnectString = "Provider=MSDataShape;Data Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;" cDataConnectString = cDataConnectString & "Initial Catalog=" & cDataName & ";Data Source = " & cServer Case "ACCESS" cDataConnectString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;" cDataConnectString = cDataConnectString & "Data Source=" & cServer If (Right(cServer, 1) <> "\") Then cDataConnectString = cDataConnectString & "\" End If cDataConnectString = cDataConnectString & cDataName Case Else MsgBox "非法调用!", vbExclamation + vbOKOnly Exit Function End Select
'////打开ADO Connect db.ConnectionString = cDataConnectString db.CursorLocation = adUseClient db.Open OpenDatabase = True Exit Function ErrHandle: OpenDatabase = False End Function Public Sub WF_Command(ByVal cCommand As String) dbMainData.Execute (cCommand) End Sub Public Sub CloseDatabase() dbMainData.Close End Sub '调用 Call OpenDatabase(dbMainData, sDataType, sLoginServer, "Master") Call WF_Command("Create Database " & sLoginName) CloseDatabase
Public dbMainData As New ADODB.Connection Function OpenDatabase(db As ADODB.Connection, ByVal cDataType As String, ByVal cServer As String, ByVal cDataName As String) As Boolean
On Error GoTo ErrHandle:
Dim cDataConnectString As String
Select Case UCase(cDataType)
Case "SQL"
cDataConnectString = "Provider=MSDataShape;Data Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;"
cDataConnectString = cDataConnectString & "Initial Catalog=" & cDataName & ";Data Source = " & cServer
Case "ACCESS"
cDataConnectString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;"
cDataConnectString = cDataConnectString & "Data Source=" & cServer
If (Right(cServer, 1) <> "\") Then
cDataConnectString = cDataConnectString & "\"
End If
cDataConnectString = cDataConnectString & cDataName
Case Else
MsgBox "非法调用!", vbExclamation + vbOKOnly
Exit Function
End Select
'////打开ADO Connect
db.ConnectionString = cDataConnectString
db.CursorLocation = adUseClient db.Open
OpenDatabase = True
Exit Function
ErrHandle:
OpenDatabase = False
End Function
Public Sub WF_Command(ByVal cCommand As String)
dbMainData.Execute (cCommand)
End Sub
Public Sub CloseDatabase()
dbMainData.Close
End Sub
'调用
Call OpenDatabase(dbMainData, sDataType, sLoginServer, "Master")
Call WF_Command("Create Database " & sLoginName)
CloseDatabase