Database Access Component

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

For more information about the objects available in ADO, see Microsoft Data Access.

Note  To use the constants specified in the ADO Reference, you must include a file that contains information about the ADO constants. For example, to use:

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

Instead of:

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

You must include the ADO Constants Include file in the .asp file by using a server-side include (SSI) statement.

If your primary scripting language is VBScript, the file you should include is named ADOVBS.INC. If you are using JScript? you should include the file named ADOJAVS.INC.

You can include them in your .asp file by using the following:


For more information about how to include files, see Including Files in Web Applications.