What is the basic data access component

What is the basic data access component

Basic data access component

Here’s a bit of information that will allow you to differentiate between these 3 data access components.

Microsoft OLE DB is "middleware" that sits between the Web client and the server to translate standard OLE function calls into database specific calls that a certain back-end database driver (for database engines SQL Server, Oracle, or Access) will understand. Essentially, OLE DB on the server lets you use the remaining components of MDAC to build your database application.

ActiveX Data Objects (ADO) are a collection of ActiveX components that provide features to retrieve data from OLE DB interfaced databases, manipulate that data, and return data to databases. ADO objects are pre-built and can be called from VBScripts as well as compiled Visual Basic and Visual C++ applications. These objects essentially allow you to rapidly develop the ActiveX based database applications without having to develop the ActiveX components yourself.

Remote Data Service (RDS) is essentially a client side data caching service that allows clients to grab complete sets of data from a server, manipulated them locally, and return them to the server. This obviates network traffic that would be involved with interactive remote manipulation, thereby speeding the process and reducing network bandwidth requirements.