title: How does the classic asp connection.errors collection actually work?
body: <p>I am trying to confirm how the actual ADODB.Connection.Errors collection should actually work. </p>
  
  <p>My interpretation at the moment is that the connection will hold all the errors for the all the procedures that have been executed on that connection.</p>
  
  <p>So I should be able to say </p>
  
  <pre><code>on error resume next 
  
  ... code goes here ... 2 or more command objects execute procedures against the database on the same connection
  
  if con.Errors &lt;&gt; 0 then 
  
    loop through all the Errors objects (1 for each procedure that would've been executed on the connection)
  
  end if 
  </code></pre>
  
  <p>However I have implemented that basic structure and I only get the one error description? So I am looking for someone to confirm that is the case. Does the Errors collection hold more than one error for more than one procedure? Or is if multiple errors occurred for one procedure?</p>
  
  <p>I can't seem to find any documentation that would indicate exactly what would happen in this case. </p>
  
  <p>Thanks,</p>