related sites: <FREE Help> <ASP> <Asp.net> <worldwide> feedback: <lovethat> <hatethat> <thanks> <credits> <contact us>
ADOMD <Next>
ADO (Active Data Objects)
A software library that allows programs to read and write databases (Access, SQLServer, Oracle, and hundreds more) and/or other Data Sources (Exchange Mail, Excel sheets, ASCII files) with almost identical code. The software library was designed with three objects (connections, recordsets, and commands) that can be used to communicate with databases, issue SQL queries, read and write data, and communicate with stored procedures.
ADO is optimized and designed to work with OLEDB drivers/providers. BUT Since ODBC drivers have been here much longer than OLEDB, ADO can uses a software layer (Microsoft nickname is Kagera) so that ADO programs can communicate with any ODBC database. Using older ODBC drivers is usually not the best choice if an equivalent OLEDB driver is available.
It is available for FREE from http://www.microsoft.com/data
Unlike its predecessors DAO or RDO this library is thread-safe/re-entrant which basically means if hundreds and thousands of calls per minute or second are made to read and write the databases the library will not have any glitches in a heavy multitasking environment.
Later versions of ADO were extended with ADOX and ADO MD.