.
BizTalk 2009: notorious Microsoft ADO MD.NET 9.0 and 10.0
When I was installing the BizTalk 2009 the Setup asked these prerequisite components:
Microsoft ADO MD.NET 9.0 and
Microsoft ADO MD.NET 10.0
I did not have Internet access and I had to manually search for these components.
Seems it is not a simple googling. :)
After painful search I've found them here:
1) ADO MD.NET 9.0:
Page "Feature Pack for Microsoft SQL Server 2005 - November 2005" - http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&displaylang=en
[- follow PageDown to]
Microsoft ADOMD.NET
...
X86 Package (SQLServer2005_ADOMD.msi) - 3302 KB
X64 Package (SQLServer2005_ADOMD_x64.msi) - 5430 KB
IA64 Package (SQLServer2005_ADOMD_ia64.msi) - 6906 KB
2) ADO MD.NET 10:
Page "Microsoft SQL Server 2008 Feature Pack, October 2008" - http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=228de03f-3b5a-428a-923f-58a033d316e1
[- follow PageDown to]
Microsoft ADOMD.NET
...
X86 Package(SQLSERVER2008_ASADOMD10.msi) - 4312 KB
X64 Package (SQLSERVER2008_ASADOMD10.msi) - 9263 KB
IA64 Package(SQLSERVER2008_ASADOMD10.msi) - 6776 KB
As you can see there is a bad inconsistency in the names!
Hope this article saves you several minutes.