Microsoft ActiveX Data Objects, or ADO, is a COM based data access layer published by Microsoft.
For .NET applications, ADO has been superceded by "Managed Ole DB providers", including ADO.NET. ADO is sometimes referred to as "ADO classic" in order to avoid confusion with ADO.NET.
ADO is a popular component for interacting with databases from applications written in Visual Basic 6.0, or Visual Basic Scripting edition (including ASP), and supercedes DAO in those languages.
SqlQueryBuilders are not tightly linked to any specific data access technology, and can therefore be used to build SQL query strings for any data access layer that accepts SQL, including ADO.
In order to use ADO types within a Visual Basic 6.0 project, it is recommended that a reference to "Microsoft ActiveX Data Objects 2.8 Library" be added to the project.
As at this writing, this is the most recently available version of ADO, and is the version used in the supplied VB6 examples. However, SqlQueryBuilders are not linked to any specific version of ADO, and most of the examples will work correctly with earlier versions of ADO.
To add a reference from the Visual Basic 6.0