Microsoft Data Access Components (MDAC) include three technologies for accessing data: ActiveX Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC).
Beekeeper Studioは無料でオープンソースのデータベースGUIです
今まで使った中で最高のSQLクエリ＆エディタツールです。データベース管理に必要なすべてが揃っています。 - ⭐⭐⭐⭐⭐ Mit
Beekeeper Studioは高速で直感的、使いやすいです。Beekeeperは多くのデータベースをサポートし、Windows、Mac、Linuxで快適に動作します。
OLE DB
Microsoft OLE DB is a set of COM interfaces that expose data from a variety of data sources including a bridge to ODBC to enable continued support for the broad range of ODBC database drivers.
ADO
ADO is an interface to OLE DB. It provides access to a variety of database systems and data structures through the OLE DB data provider.
ADO version and Windows
MDAC ships with the Windows operating system. Applications that use ADO can make use of the default version of ADO on the target Windows system. The following is a list of the default ADO versions that ship with Windows:
| Windows | ADO |
|---|---|
| Windows 98 | ADO 2.1 |
| Windows ME | ADO 2.5 |
| Windows 2000 | ADO 2.5 |
| Windows XP | ADO 2.7 |
| Windows 2003 Server | ADO 2.8 |
Visit http://msdn.microsoft.com/data/ for more information about ADO and MDAC downloads.
