ASP Tutorials - Herong's Tutorial Examples

∟ADO (ActiveX Data Object) DLL

∟"Connection" Class - Access Channel to Database

This section describes the Connection class provided in ADO DLL. The Connection class represents an access channel to a database system.

Connection: A class representing an access channel to a database system. A Connection object can be created by:

set oConn = server.CreateObject("ADODB.Connection")

There are 3 major methods offered by Connection class:

• "Open connectioinString, user, password": Method to bind this connection to a database system.
• "Close": Method to close this connection.
• "Execute commandText": Method to execute a database command through this connection.

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

 What Is ADO (ActiveX Data Object)?

►"Connection" Class - Access Channel to Database

 "RecordSets" Class - Query Output Records

 glossary.asp - ADO Example Script

 Working with MS Access Database

 Guest Book Application Example

 References

 Full Version in PDF/EPUB

"Connection" Class - Access Channel to Database - Updated in 2019, by Dr. Herong Yang