Public Sub main()
Set Con = New ADODB.Connection
With Con
.CommandTimeout = 500
.ConnectionString = ConStr
.CursorLocation = adUseClient
.Open
End With
End Sub
如果网络发生问题我在代码里如何判断,谢谢
Set Con = New ADODB.Connection
With Con
.CommandTimeout = 500
.ConnectionString = ConStr
.CursorLocation = adUseClient
.Open
End With
End Sub
如果网络发生问题我在代码里如何判断,谢谢
解决方案 »
- vb WebBrowser如何让后续打开的一系列窗口都在webbrowser控件中显示
- VB类的使用问题
- 如何取得汉字的GBK码???又如何由GBK码转换成对应的汉字???
- [求助]请问谁有MS的转码SDK,麻烦发一份给我
- 如何判断动态数组是否为空数组
- 请指教:在VB里如何为每个子程序设置"ON ERROR GOTO" ?
- 帮帮忙,很令我疑惑
- 请教:共享软件的机器码和注册码怎么产生!!来着有分!!!
- 急急!!!!!!!!!!
- 如何在程序运行中重复调用同一窗体(即在屏幕上同时显示几个相同的窗体)?
- 在vb中怎樣實現視頻的接收
- 请问我用什么方法加载树型结构最快,我们的记录是万级的。用vsflexgrid控件。
Public Sub main()
on error goto err_Handle
Set Con = New ADODB.Connection
With Con
.CommandTimeout = 500
.ConnectionString = ConStr
.CursorLocation = adUseClient
.Open
End With
exit suberr.Handle
if con.state=adstateclosed then
msgbox "连接超时,无法连接数据库服务器"
endif
End Sub
Dim ConnOK As BooleanPrivate Sub adoConn_ConnectComplete(ByVal pError As ADODB.Error, adStatus As ADODB.EventStatusEnum, ByVal pConnection As ADODB.Connection)
If adStatus = adStatusOK Then
ConnOK = True
else
msgbox "adStatus is " & adStatus '具体的错误原因查看一下msdn
end ifEnd SubPrivate Sub adoConn_WillConnect(ConnectionString As String, UserID As String, Password As String, Options As Long, adStatus As ADODB.EventStatusEnum, ByVal pConnection As ADODB.Connection)
ConnOK = False
End Sub
Public Sub main()
Set adoConn = New ADODB.Connection
With adoConn
.CommandTimeout = 500
.ConnectionString = ConStr
.CursorLocation = adUseClient
.Open
End With
End Sub
Option Explicit
Public SqlConn As New ADODB.Connection'功能简介:建立SQL数据库公共链接
'参数一:服务器名或IP
'参数二:数据库名称
'参数三:登陆用户名称
'参数四:登陆用户密码
'参数五:延时
'返回值:"ok"--成功, 否则返回错误信息
Function PulbicSQLConn(StrServerName As String, StrDataName As String, StrUserName As String, StrPassword As String, IntOutTime As Integer) As String
On Error GoTo SQLConnErr
Dim StrSql As String
StrSql = "Provider=sqloledb;Data Source=" & StrServerName & ",1433;Initial Catalog=" & StrDataName & ";User ID=" & StrUserName & ";Password=" & StrPassword & ";"
If SqlConn.State <> 0 Then SqlConn.Close
SqlConn.ConnectionTimeout = IntOutTime
SqlConn.Open StrSql
PulbicSQLConn = "ok"
Exit Function
SQLConnErr:
PulbicSQLConn = Err.Description
If SqlConn.State <> 0 Then SqlConn.Close: Set SqlConn = Nothing
End Function'功能简介:关闭SOL数据库公共链接
Function PublicMdbClose()
If SqlConn.State <> 0 Then SqlConn.Close: Set SqlConn = Nothing
End Function
msgbox "出现连接错误"
On Error Goto errHandle
Set Con = New ADODB.Connection
With Con
.CommandTimeout = 500
.ConnectionString = ConStr
.CursorLocation = adUseClient
.Open
End With
...
exit sub
errHandle:
msgbox err.description
End Sub