The Database Access component uses ActiveX® Data Objects (ADO) to access information stored in a database or other tabular data structure.
For information about ADO see http://www.microsoft.com/data/ or the Microsoft Data Access SDK in the Platform SDK.
Note To use the constants specified in the ADO Reference, you must either include a file that contains information about the ADO constants or include a reference to the ADO type library in your Global.asa file. Using a type library is generally a better option. The following example demonstrates using the ADO type library to access constants.
For example, to use:
<% rs.Open "Customers", Conn, adOpenStatic, adLockOptimistic %>
Instead of:
<% rs.Open "Customers", Conn, 3, 3 %>
You would include the following type library declaration in the Global.asa file for the application.
<!-- METADATA TYPE="typelib" FILE="c:\program files\common files\system\ado\msado20.dll"-->
For more information about type libraries and constants, see Using Variables and Constants. For more information about data access, see Accessing a Data Source and Accessing Data with ASP.