The Database Access component uses ADO (ActiveXÔ Data Objects) to access information stored in a database or other tabular data structure. It also uses the connection pooling feature of ODBC 3.0 to make database access more efficient.
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 a file that contains information about the ADO constants. For example to use:
<% rs.Open "Customers", Conn, adOpenStatic, adLockOptimistic %>
<% 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 Adojavas.inc.
These files are installed with the Active Server Pages sample files, in the \Inetpub\Aspsamp\Samples\ directory. You can include them in your .asp file by using the following:
For more information about how to include files, see Including Other Files in the Active Server Pages Scripting Guide.
© Microsoft Corporation. All rights reserved.
|file: /Techref/language/asp/comp/compref_12.htm, 2KB, , updated: 1996/11/21 19:01, local time: 2019/10/22 01:25,
|©2019 These pages are served without commercial sponsorship. (No popup ads, etc...).Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE. Questions?|
<A HREF="http://www.sxlist.com/techref/language/asp/comp/compref_12.htm"> Database Access Component</A>
|Did you find what you needed?|
Welcome to sxlist.com!
& kind contributors
just like you!
Please don't rip/copy
Copies of the site on CD
are available at minimal cost.
Welcome to www.sxlist.com!