In Chapter 7 of this book, we looked at ActiveX Data Objects (ADO), a powerful and straightforward collection of Component Object Model (COM) objects that make it possible for you to programmatically access and manipulate data in a database from within Active Server Pages.
As that chapter demonstrated, one of the features that makes ADO powerful is that it abstracts the data source. For example, to open a database connection you create a
object and call its Connection
method, specifying a data source name (DSN) as the method's parameter. Whether the database that the DSN represents is an Access, SQL Server, dBase or any other database, you connect to it in precisely the same way.Open