为什么ADO中Connection和Command的ConnectionTimeout、CommandTimeout中不起作用？

[fat1]

有没人遇到？

[liyang]

你把你的connection和command的打开方式写一下。这要看具体情况。

[fat1]

就是这句了：
Public Sub toll_connect()
On Error GoTo errhandle
If toll_conn.State = adStateOpen Then
toll_conn.Close
End If
With toll_conn
.ConnectionString = GetConnectionStr()
.ConnectionTimeout = GetConnectionTimeout()
.CommandTimeout = GetCommandTimeout()
'.CursorLocation = adUseClient
MsgBox "ConnectionTimeout:" & toll_conn.ConnectionTimeout
.Open
End With
Exit Sub
errhandle:
MsgBox "数据库连接失败！"
End
End Sub

[liyang]

在MSDN有关Adodb.Connection的ConnectionTimeout的Remark中有描述如下：
"Make sure the provider to which you are writing code supports the ConnectionTimeout functionality."

另：在MSDN有关Adodb.Command的CommandTimeout的Remark中有描述如下：
The CommandTimeout setting on a Connection object has no effect on the CommandTimeout setting on a Command object on the same Connection; that is, the Command object's CommandTimeout property does not inherit the value of the Connection object's CommandTimeout value.

On a Connection object, the CommandTimeout property remains read/write after the Connection is opened.

我一般用Provider=Microsoft.sqloledb.1
这两个属性是起作用的。

[fat1]

试了n次后：
ConnectionTimeout时好时坏，
CommandTimeout就没有好过。

[liyang]

起作用。但是时间好像不那么准。你的不起作用，要看你的程序如何用的。

[cjlong]

我也遇到过。直今不懂

[fat1]

还有没有好心人呀？