Accessing Databases with Asp & Ado

WEEK 3 - ACCESSING DATABASES WITH ASP & ADO

1.1 Introduction to ADO

- Microsoft's ActiveX Data Objects (ADO) is an interface to relational databases.

- ADO can access others types of data such as Excel, spreadsheets, delimited text

files, Exchange data, or any other type of data store for which someone has

written an Object Linking and Embedding Database (OLEDB) driver.

- Four step process when you use ActiveX Data Objects to work with databases:

o Connect to the database

o Define the data you want

o Manipulate that data

o Display the data

- There are three main objects in the ADO object model;

o The Connection Object

-In ADO, the connection object used to make and break database

connection.

-A single project called ActiveX Data Object Database(ADODB)

contains all the ADO objects.

-To create connection;

var conn = Server.CreateObject("ADODB.Connection");

o The Recordset Object

-A Recordset object is a table of values.

-It has rows and columns like a database table but actually a virtual

table or view.

-To create connection with Recordset:

var conn=Server.CreateObject("ADODB.Recordset");

o The Field Object

-In the ADO object model, Field objects contain the data.

1.2 Understanding ODBC

- ODBC (Open Database Connectivity) allows databases from different

manufacturer to work together.

- ODBC is an interpreter that makes all databases seem the same to interact with

any databases

- The ODBC Datasource Administrator applet is the tool that can be used to have

access to any number of ODBC databases.

- Database Administrator is the person who configures ODBC datasources to a

Web Server by using ODBC Datasource Administrator application.

-

...