跳转到内容

Microsoft Data Access Components

维基百科，自由的百科全书

这是本页的一个历史版本，由Regionbbs​（留言 | 贡献）在2008年9月13日 (六) 09:57编辑。这可能和当前版本存在着巨大的差异。

MDAC (Microsoft Data Access Components)
MDAC 是微軟 Windows 平台的統一資料存取方案
開發者Microsoft
当前版本2.8 SP1 (2.81.1117.6)（May 2005）
操作系统Windows 98, Windows Me, Windows NT 4, Windows 2000, Windows XP, Windows Server 2003
类型Database
许可协议Microsoft EULA
网站Microsoft MDAC Center

Microsoft Data Access Components (MDAC) 是微軟專門為資料存取功能而發展的應用程式開發介面，做為微軟的統一化資料存取 (Universal Data Access; UDA) 解決方案的核心組成，最初的版本在 1996 年時發表，其組成元件有 ODBC，OLE DB 以及 ADO，其中 ADO 是在 Visual Basic 上唯一的資料存取管道，而 OLE DB 則是基於 COM 之上，供 C/C++ 存取與提供資料的介面，ODBC 則是統一化的資料存取 API。

版本列表

微軟提供了兩個方法來檢查電腦中所安裝的 MDAC 版本為何，其中一個方法是使用 ADO.NET Component Checker 程式，它可以檢查每個 MDAC 所安裝的 DLL 版本；另一個方法是檢查登錄資料庫機碼：HKEY_LOCAL_MACHINE\Software\Microsoft\DataAccess\FullInstallVer

Version Release date Distribution mechanism Features Security issues
1.0 August 1996

No coordinated release:

  • ADC – IIS 3.0
  • OLE DB 1.1 SDK (OLE DB 1.1 and ADO 1.0) - Visual Studio
  • All components included in Visual Interdev 1.0 and with Active Server Pages (released in IIS 3.0)
  • ODBC 3.0
  • OLE DB 1.1
  • ADO 1.0
  • ADC 1.0
  • ODBC drivers for Access/Jet, SQL Server and Oracle databases

No bulletins released

1.5

September 1997 – March 1998
  • Microsoft Internet Explorer 4.0
  • Internet Client SDK 4.0 (from CD issued at Microsoft PDC)
  • ODBC 3.5
  • OLE DB 1.5
  • ADO 1.5
  • RDS 1.5 (superseded ADC 1.0)
1.5a September 1997–March 1998
  • Microsoft website

Service release

1.5b September 1997–March 1998

Service release

1.5c September 1997–March 1998
  • Microsoft website
  • Fixed issues with ADO threading and ODBC Connection Pooling
  • Only came with ADO/MDAC runtime components
2.0 July 1, 1998
  • Visual Studio 98
  • Data Access 2.0 SDK
  • ODBC 3.5 SDK
  • OLE DB 1.5 SDK
  • OLE DB for OLAP Specification
2.0SP1 July 1, 1998
  • Windows NT 4.0 SP4

Y2K remediation for Windows NT 4.0

2.0SP2 July 1, 1998
  • Microsoft website

Y2K remediation for all platforms

2.1 July 11, 1998
  • SQL Server 7.0
  • SQL Server 6.5 SP5
  • ADO 2.1
  • RDS 2.1
  • OLE DB 2.1
  • OLE DB Provider for ODBC, SQL Server and Oracle
  • JRO 2.1
  • ODBC driver
  • Jet driver
  • RDO
2.1 SP1 March 15, 1999
  • Internet Explorer 5.0
  • Windows 98 Second Edition
2.1 SP1a (GA) April 1, 1999
  • Office 2000
  • BackOffice 4.5
  • Visual Studio 98 SP3
  • Internet Explorer 5.0a (minimal install)
2.1 SP2 July 1999
  • Microsoft website
2.5 February 17, 2000
  • ADO 2.5
  • ADO MD 2.5
  • ADOX 2.5
  • RDS 2.5
  • OLE DB 2.5
  • OLE DB Provider for the ODBC driver for:
    • SQL
    • Server
    • Site Server Search
    • Internet Publishing
    • Jet 4.0 (Access 2000)
    • Oracle
    • Indexing Services (Index Server)
    • Microsoft Data Shaping Services
    • OLAP Services
    • DTS Packages
    • Microsoft Directory Services
    • Server DTS Flat File
    • OLE DB Simple Provider
  • JRO 2.5
  • ODBC 3.51
  • an ODBC driver for
    • Microsoft Access
    • SQL Server
    • Microsoft Excel
    • Text
    • Visual FoxPro
    • FoxPro VFP
    • dBase
    • dBase VFP
    • Paradox
    • Oracle
  • Jet drivers for:
    • Excel
    • Microsoft Exchange
    • Access
    • text files
    • Lotus 1-2-3
    • Paradox
    • xBase
2.5 SP1 July 31, 2000
2.5 SP2 April 2000
2.5 SPS3 December 2003

2.6

September 2000

Not included (manually installed):
  • Microsoft Jet
  • Microsoft Jet OLE DB Provider
  • ODBC Desktop Database Drivers
2.6 SP1 May 2001
2.6 SP2 May 2002
2.7 October 2001
  • Support for 64-bit operating systems
  • Banyan Vines support dropped
2.8 August 2003

Fixed bugs and security issues

2.8 SP1 May 2005
  • SQL Server 2000 SP4
  • Windows XP SP2
  • Microsoft website

Fixed bugs

2.8 SP2 March 2005
  • Windows Server 2003 SP1
9.0 Never released: Microsoft now includes MDAC with operating system updates.
  • Visual Studio 2005 Beta 1, but later removed.
  • Originally released with SQL Server 2005 Beta 1, but later removed.[1]
    
Windows DAC 6.0 (a variant of MDAC for use with Vista) November 2006
  • Windows Vista
  • Version number synchronized with Windows version, non-redistributable

No new features, for use with Windows Vista


參考資料

  1. ^ Chapter 11 Changes, supplementary material to "A First Look at SQL Server 2005 for Developers" by Bob Beauchemin, Niels Berglund, and Dan Sullivan.
检索自“https://zh.wikipedia.org/w/index.php?title=Microsoft_Data_Access_Components&oldid=8084339”