title: using recordset in classic asp
body: <p>I am trying to fetch data from database using recordset with following code in classic ASP .I am using windows 7 32 bit OS:</p>
  
  <pre><code>&lt;%
  dim con,rs
  set con=Server.Createobject("ADODB.Connection")
  con.Provider="Microsoft.Jet.OLEDB.4.0"
  con.Open "c:\inetpub\wwwroot\New folder\123.mdb"
  rs.Open "select * from student",con
  for each x in rs.fields
  response.write(x.name)
  response.write("=")
  response.write(x.value)
  next
  rs.Close
  con.Close
  %&gt;
  </code></pre>
  
  <p>error is:</p>
  
  <pre><code>Microsoft VBScript runtime error '800a01a8'
  
  Object required: ''
  
  /New folder/recordset.asp, line 7
  </code></pre>