Paste this code into a file and save it as example2.asp in your sample folder.

 <html>
 <body> 
 <%Set Conn = Server.CreateObject("ADODB.Connection") 
Conn.Open "NorthwindDSN" 
sql = "SELECT LastName, FirstName FROM Employees WHERE LastName = 'Reid' " 
Set rst = Conn.Execute(sql) 
If rst.EOF Then
      Response.Write "No employee records available"
      Conn.Close
      Set Conn = Nothing
      Response.End 
End if %> 
 <%Do While Not rst.EOF%> 
     <%=rst("LastName")%> 
     <%=rst("FirstName")%>   
     <%=rst.MoveNext 
Loop 
Set Conn = Nothing 
Set rst = Nothing %> 
 </body> 
 </html> 

Click Next for example3.asp