Essay About Microsofts Activex Data Objects And Understanding Odbc

Accessing Databases with Asp & Ado
WEEK 3 – ACCESSING DATABASES WITH ASP & ADO
1.1 Introduction to ADO
– Microsofts 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.