Definition: ADO is short for Activex Data Objects and is a set of COM clases for accessing databases such as SQL Server or MySql.
ADO allows connections to databases to be defined by a connection string. Once connected, SQL queries can be run on those databases to insert new data, modify existing data or return results from them.
The beauty of ADO is that it standardises the interface to different databases, once a low level driver (called a provider) has been written.
Glossary:
A B C D E F G H I J K L M N O P Q R S T U V W X Y ZExamples:
There are ADO providers available for most of the popular databases and even text files and Microsoft Excel files.
