Activex Data Objects Shopping
Activex 		Website Links For
Activex 		 

Information About

Activex Data Objects
  CATEGORIES ABOUT ACTIVEX DATA OBJECTS
   
microsoft apis
   
APPAREL
BABY
BEAUTY
BOOKS
CAR TOYS
CELL PHONES
DVD'S
ELECTRONICS
GOURMET FOOD
GROCERIES
HEALTH & PERSONAL
HOME & GARDEN
JEWELRY
MUSIC
MUSIC INSTRUMENTS
OFFICE PRODUCTS
SOFTWARE
SPORTING GOODS
TOOLS & HARDWARE
TOYS
VIDEO GAMES
SHOPPING HOME
MORE SHOPPING...



It is positioned as a successor to Microsoft's earlier object layers for accessing data sources, including RDO (Remote Data Objects) and DAO (Data Access Objects). ADO was introduced by Microsoft in the winter of 1996 .

ADO consists of several top-level objects:

  • Connection (represents the connection to the database)

  • Recordset (represents a set of database records)

  • Command (represents a SQL command)

  • Record (represents a set of data, typically from a source other than a database)

  • Stream (represents a stream of data, as from a text file or web page)

  • Error (stores errors)

  • Field (represents a database field)

  • Parameter (represents a SQL parameter)

  • Property (stores information about objects)


ADO component is used in conjunction with a high-level language, such as VBScript in an Active Server Pages (ASP) environment, or Visual Basic. Even Delphi , a development environment from Microsoft rival Borland Coporation, now allows the use of ADO to access various databases.

In the newer programming framework of .NET, Microsoft also presented an upgraded version of ADO called ADO.NET . Its object structure is quite different from that of traditional ADO. Traditional ADO is still very popular, and is often perceived as being more mature.

Here is an ASP example using ADO to select the "Name" field, from a table called "Phonebook", where a "PhoneNumber" was equal to "555-5555".

dim myconnection, myrecordset, name
set myconnection = server.createobject("ADODB.Connection")
set myrecordset = server.createobject("ADODB.Recordset")

myconnection.open mydatasource
myrecordset.open "Phonebook", myconnection
myrecordset.find "PhoneNumber = '555-5555'"
name = myrecordset.fields.item("Name")
myrecordset.close

set myrecordset = nothing
set myconnection = nothing

This is equivalent to the following ASP code, which uses plain SQL, instead of the functionality of the Recordset object:

dim myconnection, myrecordset, name
set myconnection = server.createobject("ADODB.connection")
myconnection.open mydatasource
set myrecordset = myconnection.execute("SELECT Name FROM Phonebook WHERE PhoneNumber = '555-5555'")
name = myrecordset(0)
myrecordset.close

set myrecordset = nothing
set myconnection = nothing


EXTERNAL LINKS