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/6/18 07:21,
|©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.piclist.com/techref/language/asp/comp/compref_12.htm"> Database Access Component</A>
|Did you find what you needed?|
PICList 2019 contributors:
o List host: MIT, Site host massmind.org, Top posters @20190618 RussellMc, David Van Horn, AB Pearce - UKRI STFC, Dwayne Reid, Bob Blick, Jason White, David C Brown, James Cameron, Allen Mulvey, Jim,
* Page Editors: James Newton, David Cary, and YOU!
* Roman Black of Black Robotics donates from sales of Linistep stepper controller kits.
* Ashley Roll of Digital Nemesis donates from sales of RCL-1 RS232 to TTL converters.
* Monthly Subscribers: Gregg Rew. on-going support is MOST appreciated!
* Contributors: Richard Seriani, Sr.
Welcome to www.piclist.com!