What are ActiveX data Objects in ASP?
Hy; Say… ADO (ActiveX Data Object) is binary containing the respective classes and methods for handling the data in the database (any), may be microsoft or non microsoft. It can reach to any level of the database degree in the terms of Data manipulation language (DML) or Data definition language (DDL). So ADO in ASP, is the ability of accessing the data from database and put in on the web page when the web user requests for something od some kind of information which is stored in database. Through ADO the data (or the content) are displays dynamically. Basically ADO is used in ASP at the server level where it executes the users request in the server and sends only the output to the user. So the data is safe and cannot be accessed without authentication. In ASP, you can collect the information and store in DB via ADO or you can pull the information from DB and put it on the display…. like simply… a feed back form… where you collect the feedback from the end user and store them i
It provides a layer between programming languages and OLE DB (a means of accessing data stores, whether they be databases or otherwise, in a uniform manner). ADO allows a developer to write programs that access data without knowing how the database is implemented. You must be aware of your database for connection only. No knowledge of SQL is required to access a database when using ADO, although one can use ADO to execute arbitrary SQL commands. The disadvantage of this (i.e. using SQL directly) is that it introduces a dependency upon the type of database used.
