CommandTimeout does not inherit from Connection timeout

MORE INFORMATION

Steps to reproduce the behavior

1. Start a Visual Basic Project.
2. Set a Project Reference to the Microsoft ActiveX Data Objects Library.
3. Paste the following code in the Form_Load() event of the default form. You need to modify the connection string so that it references a valid datasouce.

         Dim cnn As New ADODB.Connection
         Dim cnstring As String
         cnstring = "Provider = SQLOLEDB;" & _
                    "DATA SOURCE =<server name>;" & _
                    "USER ID = <user id>;" & _
                    "PASSWORD =<password>;" & _
                    "INITIAL CATALOG = <database>;"
         cnn.CommandTimeout = 0
         cnn.Open cnstring
         Dim cmd As New ADODB.Command
         cmd.ActiveConnection = cnn
         Debug.Print "Timeout on Connection: " & cnn.CommandTimeout
         Debug.Print "Timeout on Command:  " & cmd.CommandTimeout
   					

4. Run the form. You should see that the timeout for the Connection object is set to zero (0) as expected, while the timeout for the Command object is 30 seconds (which is the default).