title: ASP classic recordset error '8007000e' Out of memory
body: <p>I have a script which exports a recordset to excel. My recordset has 139 columns. I can see in fiddler that table header of the excel is created but when it comes to write the values I face this error:</p>
  
  <p>Microsoft Cursor Engine error '8007000e'</p>
  
  <p>Out of memory.</p>
  
  <p>/includes/ExportFunctions.inc, line 49</p>
  
  <p>when I remove 5 columns then it works quite fine, even the null valued columns! It is so strange to me because I can not find any limitation for recordsets and I am sure I have disposed all the objects required.
  Here is my code:</p>
  
  <pre><code>Response.Write "&lt;table&gt;" &amp; vbCrLf
  Response.Write "&lt;tr&gt;" &amp; vbCrLf
  For intItem = 0 To rstResult.Fields.count - 1
      Response.Write "&lt;th&gt;" &amp; rstResult(intItem).Name &amp; "&lt;/th&gt;" &amp; vbCrLf
  Next    
  Response.Write "&lt;/tr&gt;" &amp; vbCrLf
  dim index 
  index = 0 
  Do While Not rstResult.EOF
      Response.Write "&lt;tr&gt;" &amp; vbCrLf
      For intItem = 0 To rstResult.Fields.count - 1
          Response.Write "&lt;td&gt;&lt;nobr&gt;"
          If IsNull(rstResult(intItem).Value) Then
              Response.Write " "
          else
              Response.Write rstResult(intItem).Value
          end if
          Response.Write "&lt;/nobr&gt;&lt;/td&gt;" &amp; vbCrLf
      Next    
      Response.Write "&lt;/tr&gt;" &amp; vbCrLf
  
      Response.Flush
  
      rstResult.MoveNext
  LOOP
  </code></pre>
  
  <p>The error refers to line 49 which is </p>
  
  <pre><code>Do While Not rstResult.EOF
  </code></pre>
  
  <p>Does anyone has an idea about this?</p>