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

 <html> 
 <body> 
 <%Set Conn = Server.CreateObject("ADODB.Connection") 
Conn.Open "NorthwindDSN" 
sql = "SELECT LastName, FirstName FROM Employees" 
Set rst = Conn.Execute(sql) %> 
 <%Do While Not rst.EOF%>
    <%=rst("LastName")%>
    <%=rst("FirstName")%>
    <%=rst.MoveNext 
Loop
 Set Conn = Nothing
 Set rst = Nothing %> 
 </body> 
 </html> 

Click Next for example2.asp