To connect to a database using ADO in Classic ASP, you typically use the ADODB.Connection object. This is called an ADO Connection.

? Step-by-Step: ADO Connection in Classic ASP

? 1. Create the Connection Object

<%Dim connSet conn = Server.CreateObject("ADODB.Connection")%>

? 2. Set the Connection String

This depends on the database you're using.

? Example: Microsoft Access

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database.mdb")

? Example: SQL Server

conn.Open "Provider=SQLOLEDB;Data Source=SERVER_NAME;Initial Catalog=DATABASE_NAME;User ID=USERNAME;Password=PASSWORD;"

? Example: MySQL (via ODBC DSN)

conn.Open "DSN=MySQL_DSN;UID=username;PWD=password;"

? 3. Use the Connection (e.g., run SQL)

Dim rs, sqlsql = "SELECT * FROM Users"Set rs = conn.Execute(sql)Do Until rs.EOF    Response.Write rs("Name") & "<br>"    rs.MoveNextLooprs.CloseSet rs = Nothing

? 4. Close the Connection

conn.CloseSet conn = Nothing%>

? Tip:

You can put the connection code in an include file (e.g., dbconnect.asp) for reusability:

<!--#include file="dbconnect.asp" -->

Let me know your database type (Access, SQL Server, MySQL, etc.) if you want a tailored example.