An ADO Example

Here is a part of a simple ASP script that creates an ADO Recordset on a database called Pubs:<% Dim rs Set rs = Server.CreateObject _ ("ADODB.Recordset") rs.Open "Authors", "DSN=pubs” %>

After the query, you can use the recordset to write HTML output <% Response.Write rs("au_fname") & " " _ & rs("au_lname") %>or<%= rs("au_fname") & " " & rs("au_lname") %>

Here is a part of a simple ASP script that creates an ADO Recordset on a database called Pubs: <% Dim rs Set rs = Server.CreateObject _ ("ADODB.Recordset") rs.Open "Authors", "DSN=pubs” %>