连接数据库时,如果连接不上需要等待老长时间才返回错误信息
连接数据库时,如果连接不上需要等待老长时间才返回错误信息,怎么处理?
我的连接代码如下:
Public Sub DBConnectupdate(ByVal UID As String, ByVal PWD As String, ByVal DBName As String, ByVal ServerName As String)
If cnnupdate.State Then cnnupdate.Close
cnnupdate.ConnectionString = "Provider=SQLOLEDB.1;Password=" & PWD & ";Persist Security Info=False;User ID=" & UID & ";Initial Catalog=" & DBName & ";Data Source=" & ServerName
cnnupdate.ConnectionTimeout = 2
cnnupdate.Open
End Sub
////////////////
cnnupdate.ConnectionTimeout = 2不能设置超时吗?