title: ADO Connection Timeout
body: <p>I am seeing a timeout error for some users w/large transactions. I am not clear the implications of:</p>
  
  <ol>
  <li>Using cnn.ConnectionTimeout vs cnn.CommandTimeout?</li>
  <li>Setting a very long timeout period (how long is too long?)</li>
  <li>Setting timeout = 0 (indeterminate?)</li>
  </ol>
  
  <p>Here is a snippet:</p>
  
  <pre><code>Set cnn = New ADODB.Connection
  
  'cnn.ConnectionTimeout = 30    
  'cnn.CommandTimeout = 30
  
  cnn.CursorLocation = adUseClient
  cnn.ConnectionString = "driver={SQL Server}; server=" &amp; myIP &amp; ";Trusted_Connection=no;Database=" &amp; myDatabase &amp; ";UID= " &amp; myUser &amp; ";PWD= " &amp; myPass &amp; "
  cnn.Open
  
  strSQL = "uspDeleteAreaCommon @InvID = '" &amp; myInvID &amp; "';"
  Set rs = cnn.Execute(strSQL)
  </code></pre>
  
  <p>Any suggestions/cautions??</p>
  
  <p>Thanks!</p>