Where is ADODB 2.8 on Server 2008 / Vista ?

Question

I've been developing a C# project that references the ADODB 2.8 COM on a Windows 2005 machine. (No I'm not using it for data access I need it because CDO needs returns ADODB.Streams).

Now I've tried opening this solution on a Server 2008 box but I'm told ADOB 2.8 is missing and sure enough there aren't any ADODB items in the COM references list and the /programs files/Common Files/microsoft shared/ folder is missing the ado folder.

Now I understand that Vista / Server 2008 has Windows DAC 6.0 which is what MDAC is now called, so I'm retisent to just go ahead and install MDAC.

Anyone else come across or solved this? Is there another place I can get hold of an interop for ADODB.Stream? Should I be using MDAC 2.8?

Answer 1

The documentation for DAC (located at http://msdn.microsoft.com/en-us/library/ms692877(VS.85).aspx) states (emphasis mine):

Windows DAC includes some changes to work with Windows Vista, but is almost entirely functionally equivalent to MDAC 2.8.

It's because of that "almost" which makes me use MDAC 2.8 when I need to use ADO 2.8, not Windows DAC.

For completeness, MDAC 2.8 can be located here:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6c050fe3-c795-4b7d-b037-185d0506396c&displaylang=en