我用以下语句连接SQL Server数据库
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=silk;Data Source=SERVER"
Adodc1.RecordSource = "select * from 客户资料"
Adodc1.Refresh
可是如果网络断开就会出现程序错误而中断,
能不能加一个判断语句来判断SQL是否已经连接?
Adodc1.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=silk;Data Source=SERVER"
Adodc1.RecordSource = "select * from 客户资料"
Adodc1.Refresh
可是如果网络断开就会出现程序错误而中断,
能不能加一个判断语句来判断SQL是否已经连接?
问题是判断如果连接不成功则提示网络连接错误,但如果是On Error的话,不一定是连接不成功的问题才会产生On Error嘛.
On Error GoTo showerr
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionString = Connection_String
conn.Open
MsgBox "连接成功", vbOKOnly + vbInformation, "测试连接"
Exit Sub
showerr:
MsgBox "Error:" & Err.Number & vbCrLf & Err.Description, vbOKOnly, ""
End Sub
其实 heiheidan ()是他的具体话