Before using the ADO Objects to access your database you need to load them into memory from the ADODB library.  For ASP this is different than in VisualBASIC.  To load the ADO Objects you are going to use into memory you must first declare the variable names with the Dim statement.  Then use the Set statement and Server.CreateObject function to create them.

Example:

Dim Conn, RS        'Declares the Conn (Connection) and RS (Recordset) variables

Set Conn = Server.CreateObject("ADODB.Connection")
Set RS = Server.CreateObject("ADODB.Recordset")

By: Matthew Holder