Glossary

Visit us at: http://www.db2asp.com

Glossary

ADO
ActiveX Data Objects is an automation-based interface for accessing data. Application programming interface to MDAC. If installed, look in "C:\Program Files\Common Files\System\ADO\ADOReadMe.TXT" for supplementary information. To install, see ADO Redistributable below.

ADO 2.0 -- Has OLE DB provider for Access 97 and DBF files.
ADO 2.1 -- Has OLD DB provider for Access 2000.

ADOX
ADO Extensions for Data Definition and Security. ADOX exposes additional objects for creating, modifying, and deleting schema objects such as tables and procedures. It also includes security objects to maintain users and groups and to grant and revoke permissions on objects. If installed, look in "C:\Program Files\Common Files\System\ADO\ADOXReadMe.TXT" for supplementary information.

DAO
Data Access Objects. Microsoft technology that preceded ADO.

DAO 3.51 - Access 97 mdb file, direct use of DBF files.
DAO 3.60 -- Access 2000 mdb file.

BDE
Borland Database Engine.

MDAC
Microsoft Data Access Components includes ADO, ODBC and OLE DB. If installed, look in "C:\Program Files\Common Files\ System\ADO\ MDACReadMe.TXT" for supplementary information. To install, see ADO Redistributable below.

ODBC
Open Database Connectivity is included in MDAC only for backward compatibility. ODBC drivers will likely be replaced by OLE DB providers in the future.

OLE DB
OLE DB is included in MDAC. Successor to ODBC. Also supports ODBC.

UDA
Universal Data Access is part of Microsoft's strategy of providing access to data in both relational and non-relational data stores.