Version 2.6 or higher, 2.8 is recommended.
http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDACDownloads
(Opens a new window)
You may have already have a version installed...Windows OS/Software and Default MDAC version:
- Windows Server 2003 - 2.8
- Windows XP - 2.7
- Microsoft SQL Server 2000 Service Pack 3a - 2.71 SP1 Refresh
- SQL Server 2000 SP2 - 2.6 SP2
- SQL Server 2000 SP1 - 2.6.1
- Windows 2000 Service Pack 3 - 2.5 SP3
- Windows 98/ME/NT should download and install the newest version of MDAC.