Using a Database Connection (ADO)

In this ASP code snippet, we'll explore how to establish a database connection using ADO (ActiveX Data Objects) in Active Server Pages. Database connections are essential for retrieving, manipulating, and displaying data from a database within your web applications.

<% 
Dim conn, rs
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\path\to\your\database.mdb;"

Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT * FROM your_table", conn

Do Until rs.EOF
    Response.Write(rs("column_name") & "<br>")
    rs.MoveNext
Loop

rs.Close
conn.Close
Set rs = Nothing
Set conn = Nothing
%>