Database Access Component

The Database Access Component uses ADO (ActiveX Data Objects) to access information stored in a database or other tabular data structure.

For more information about the objects available in ADO, see the ActiveX Data Objects Reference.

Note To use the constants specified in the ADO Reference, you must include the file, Adovbs.h in the .asp file. (This file is installed with the Active Server Pages sample files, in the \Inetpub\Aspsamp\Samples\ directory.) For example, to write:

<% rs.Open "Customers", Conn, adOpenStatic, adLockOptimistic %>
 

Instead of:

<% rs.Open "Customers", Conn, 3, 3 %>
 

You must include Adovbs.h in the .asp file containing the script by using a Server-Side Include (SSI) statement, such as the following:

<!--#include virtual="/ASPSAMP/SAMPLES/ADOVBS.H"-->
 

For more information about SSIs, see the Active Server Pages Scripting Guide.