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.
