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
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