The Full Form of ADODB is Active Data Objects Data Base.
ActiveX Data Objects is a programming model, which means that it is not dependent upon any given back-end engine. Currently, however, the only engine supporting the ADO model is OLE-DB. There are many native OLE-DB Providers as well as an OLE-DB Provider for ODBC. ADO is used in C++ and Visual Basic programs to connect to SQL Server and other databases. Of course, it also works to connect to Azure SQL Database in the cloud.
There are three versions of ADO in common use: 2.1, 2.5 and 2.6. Version 2.5 comes as standard with Windows 2000 or higher.
When using ADO you must have a reference to (Microsoft ActiveX Data Objects 2.5 Library) or the corresponding version in your Tools > References for that current Project
ADO doesn’t actually access the data source directly but through a OLE DB.
Most OLE DB providers are specific to a single type of data source
Dynaset – a query based recordeset
ADODB
means
Active Data Objects Data Base
Leave a Reply
You must be logged in to post a comment.