ASP 101 - Active Server Pages 101 - Web04
The Place ASP Developers Go!



Windows Technology Windows Technology
15 Seconds
4GuysFromRolla.com
ASP 101
ASP Wire
VB Forums
VB Wire
WinDrivers.com
internet.commerce internet.commerce
Partners & Affiliates
ASP 101 is an
internet.com site
ASP 101 is an internet.com site
IT
Developer
Internet News
Small Business
Personal Technology

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

ASP 101 News Flash ASP 101 News Flash



 Top ASP 101 Stories Top ASP 101 Stories
Connections, Commands, And Procedures
What is ASP?
VBScript Classes: Part 1 of N

QUICK TIP:
Use Option Strict
Show All Tips >>
ASP 101 RSS Feed ASP 101 Updates


Quick Tips


Query your database with ADO

Microsoft created ActiveX Data Objects (ADO) to serve as the central model for building database interaction within Web pages. Language-independent ActiveX Data Objects can connect your Web pages to any ODBC-compliant database. Microsoft implemented ADO specifically to provide data access across the Web. The idea behind ADO is to provide an object-based interface that makes remote objects appear as if they were local. The benefits of the ADO model include low memory overhead and high speed, important considerations for Web-based applications.

Built on top of Microsoft's OLE database model, ADO is the successor to both Remote Data Objects (RDO) and Data Access Object (DAO).

ADO lets you use ActiveX scripting to connect to your datasource. You also can use ActiveX scripting to customize the properties and methods of an ActiveX Data Object. ADO supports transactions, cursors, error handling, and the use of stored procedures.

When using ADO, be sure to keep these three tips in mind:

  1. Create the recordset object if you are executing a single command once.
  2. Create the command object if you are executing the same command multiple times.
  3. Create the connection object if you are executing multiple commands.

Previous      Show All Tips      Next

If you have a tip you would like to submit, please send it to: webmaster@asp101.com.


Home |  News |  Samples |  Articles |  Lessons |  Resources |  Forum |  Links |  Search |  Feedback

Internet.com
The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers