ADODB question

[Imagination]

Hello,

Regarding the following 2 functions, what does .CommandTimout do versus .ConnectionTimeOut?

Public Function OpenDatabase(ByVal connectString As String) As ADODB.Connection
On Error Resume Next
Dim db As New ADODB.Connection
db.CommandTimeout = 0
db.Open (connectString)
Set OpenDatabase = db
Exit Function
End Function

Public Function OpenDatabase(ByVal connectString As String) As ADODB.Connection
On Error Resume Next
Dim db As New ADODB.Connection
db.ConnectionTimeout = 0
db.Open (connectString)
Set OpenDatabase = db
Exit Function
End Function


Thanks

 

[BoberFett]

CommandTimeout is just that, it's the timeout for commands, such as queries while ConnectionTimeout only applies to making the connection the db.