title: Asp-Classic ADODB Recordset missing Records
body: <p>one of the simplest Components in my website just stopped working from one day to the other without any changes in Code. </p>
  
  <pre><code>'Connection Declaration as connection
  Set rs = Server.CreateObject ("ADODB.Recordset")
  rs.Open "SELECT * FROM tablename ORDER BY id DESC", connection, 1, 3
  while not rs.EOF
    'writing some Table from the records in DB
    'Simplified Code %&gt;
    &lt;tr&gt;&lt;td&gt;&lt;%=rs("id")%&gt;&lt;/td&gt;&lt;td&gt;&lt;%=rs("description")&amp;&gt;&lt;/td&gt;&lt;/tr&gt;
    &lt;%
    rs.MoveNext
  Wend
  </code></pre>
  
  <p>in my Database i have verified the extraordinary number of 30 records :(</p>
  
  <p>when above code is executed i see 2 of them</p>
  
  <p>This tells me two things,  </p>
  
  <blockquote>
    <p>first: the tablename is Correct and the connection to the Database is established<br>
    second: the table-generation in itself is correct</p>
  </blockquote>
  
  <p>I also have a smaller Testing-System. there the exact same code on a sample Database produces the expected Results. </p>
  
  <p>Unfortunately i have no means of "instant-access" to my main page for "debugging purposes"</p>
  
  <p>Is there any known Bugs for ADODB Recordsets losing records? Please keep in mind the Code is exactly the same and working "error-free". </p>