Dim cnn As New ADODB.Connection
Dim cust As New ADODB.Recordset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + _
dd+ "\dipanhao2.mdb';Persist Security Info=False"
如何判断cnn是否连接成功?
Dim cust As New ADODB.Recordset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + _
dd+ "\dipanhao2.mdb';Persist Security Info=False"
如何判断cnn是否连接成功?
...
Dim cnn As New ADODB.Connection
Dim cust As New ADODB.Recordset
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + _
dd+ "\dipanhao2.mdb';Persist Security Info=False"...
err:
select case err.number
case 0
case else
msgbox err.Description
'这里根据错误代码,再判断是否连接成功
end select
Dim cust As New ADODB.RecordsetOn Error Goto ConnError
cnn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + _
dd+ "\dipanhao2.mdb';Persist Security Info=False"
..................
ConnError:
MsgBox "数据库连接失败!" & vbCrLf
_ & Err.Description
debug.print "Sucess!"
end f
On Error GoTo err_checkdb
If Not IsNull(s_db.Version) Then
Check_DB_Opened = True
End If
Exit Function
err_checkdb:
If Err.Number = 424 Or Err.Number = 91 Then
Err.Clear
Check_DB_Opened = False
End If
End Function