ADO on NT4 Workstation

Question

I tried unregistering ado 1.5 and 1.0. I can't find msado20.dll, which is weird. I've installed SP5a, and run the mdac_typ.exe from the SP5a directory (moving it to other location first), which claimed to install MDAC 2.1 fine. Doesn't this include ADO2.0? I've searched microsoft.com/data for any downloads that look like "ADO 2.0 complete install for people that don't know what they're doing", but can't find anything <g>

I've got the file MSADO20.TLB, but no DLL.

Answer

From: Shamil Salakhetdinov <shamil@marta.darts.spb.ru>
To: OLE DB Discussions <oledb@listserv.swynk.com>
Subject: Re: [oledb] Re: ADO on NT4 Workstation
Date: 16 February 1999 2:00

Dave,

msado20.dll does not exists - ADO 2.0/2.1 is in msado15.dll - below you can see how its typelib is registered on my PC - as you see there are two versions registered pointing the same msado15.dll - these are COM tricks is action:

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}]

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.0]
@="Microsoft ActiveX Data Objects 2.0 Library"

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.0\0]

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.0\0\win3
2]
@="C:\\Program Files\\Common Files\\system\\ado\\msado15.dll"

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.0\FLAGS]
@="0"

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.0\HELPDI
R]
@="C:\\Program Files\\Common Files\\system\\ado\\"

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.1]
@="Microsoft ActiveX Data Objects 2.1 Library"

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.1\0]

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.1\0\win3
2]
@="C:\\Program Files\\Common Files\\System\\Ado\\msado15.dll"

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.1\FLAGS]
@="0"

[HKEY_CLASSES_ROOT\TypeLib\{00000200-0000-0010-8000-00AA006D2EA4}\2.1\HELPDI
R]
@="C:\\Program Files\\Common Files\\System\\Ado\\"

You can also look through "ASP 2.0 Programmer's Reference" 1998 by WROX, page 171:

"Don't be fooled by the name of the DLL - it has the same name whatever version of ADO."

HTH,
Shamil