Private Sub Command1_Click() Call RegisterDatabase End SubPrivate Sub RegisterDatabase() Dim DB As Database Dim ms As String '描诉 Dim sx As String '属性 Dim errN As Errorms = "我的数据库" sx = "Database=Students" & vbCr & _ "Description=" & ms & _ vbCr & "OemToAnsi=No" & vbCr & "Server=Server1" On Error GoTo Err_Register DBEngine.RegisterDatabase "Students", _ "SQL Server", True, sx On Error GoTo 0 MsgBox "look Regester!" Exit Sub Err_Register: If DBEngine.Errors.Count > 0 Then For Each errN In DBEngine.Errors MsgBox "错误号:" & errN.Number _ & vbCr & errN.Description Next errN End If Resume Next End Sub
Call RegisterDatabase
End SubPrivate Sub RegisterDatabase()
Dim DB As Database
Dim ms As String '描诉
Dim sx As String '属性
Dim errN As Errorms = "我的数据库"
sx = "Database=Students" & vbCr & _
"Description=" & ms & _
vbCr & "OemToAnsi=No" & vbCr & "Server=Server1"
On Error GoTo Err_Register
DBEngine.RegisterDatabase "Students", _
"SQL Server", True, sx
On Error GoTo 0
MsgBox "look Regester!"
Exit Sub
Err_Register:
If DBEngine.Errors.Count > 0 Then
For Each errN In DBEngine.Errors
MsgBox "错误号:" & errN.Number _
& vbCr & errN.Description
Next errN
End If
Resume Next
End Sub