ASP Tutorials - Herong's Tutorial Examples

∟ADO (ActiveX Data Object) DLL

This chapter provides tutorial notes and example codes on ADO DLL. Topics include introduction of ADO (ActiveX Data Object) DLL; using Connection and RecordSets classes; opening database connections; running SQL queries.

What Is ADO (ActiveX Data Object)?

"Connection" Class - Access Channel to Database

"RecordSets" Class - Query Output Records

glossary.asp - ADO Example Script

Takeaways:

• ADO is an API for ASP script pages to interact with database systems.
• ADO offers two classes, Connection and RecordSets, to provide database access and run SQL queries.

Table of Contents

 About This Book

 ASP (Active Server Pages) Introduction

 IIS (Internet Information Services) 5.0

 MS Script Debugger

 VBScript Language

 ASP Built-in Run-time Objects

 ASP Session

 Creating and Managing Cookies

 Managing Sessions with and without Cookies

 scrrun.dll - Scripting Runtime DLL

 Managing Response Header Lines

 Calculation Speed and Response Time

►ADO (ActiveX Data Object) DLL

 Working with MS Access Database

 Guest Book Application Example

 References

 Full Version in PDF/EPUB

ADO (ActiveX Data Object) DLL - Updated in 2019, by Dr. Herong Yang