Public Function Connected(CString As String) As Boolean
Dim intStatus As Integer
Dim Cnxn1 As ADODB.Connection
On Error Resume Next
Set Cnxn1 = New ADODB.Connection
Cnxn1.ConnectionString = CString
Cnxn1.CommandTimeout = 10
Cnxn1.Open
Select Case Cnxn1.State
Case 0
Connected = False
Case 1
Connected = True
End Select
If Not Cnxn1 Is Nothing Then
If Cnxn1.State = adStateOpen Then Cnxn1.Close
End If
Set Cnxn1 = Nothing
' If Err <> 0 Then
' MsgBox Err.Source & "-->" & Err.Description, , "Error"
' End If
End Function
Dim cn As Object
Dim rs As Object
Dim connstr As String
Set cn = New ADODB.Connection
If cn.State = adStateOpen Then cn.Close
cn.Provider = "Microsoft.Jet.OLEDB.4.0"
cn.ConnectionString =connectionString
cn.Open
Set rs = New ADODB.Recordset
With rs
Set .ActiveConnection = cn
.CursorType = adOpenStatic
.LockType = adLockOptimistic
.Open StrSql
End With
If cn.State = adStateOpen Then
cn.Close
cn.ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0 ;Persist Security Info=False;Data Source= datasource")
On Error GoTo err
cn.Open
Call MsgBox("测试连接成功!", vbOKOnly, "提示!")
cn.Close
Exit Sub
err:
Call MsgBox("测试连接失败!请重新选择数据库配置.", vbCritical, "警告!")
End If