What we need while using database in ASP?

When ASP does some database functions, it will require an ADO object. The ADO is a kind of ActiveX Object.

We need to use the "Server.Create" Object to make a new ADO object.

For example:

This is an ADO connection:

<% Set conn = Server.CreateObject("Adodb.Connection") %>

This is an ADO recordset:

<% Set rs = Server.CreateObject("Adodb.Recordset") %>