7 replies to this topic

[Mark Lloyd]

 gUiTaR_mIkE, on May 18 2009, 09:42 AM, said:

If you could report your experiences with KB961373 (DX8)/(DX9) (was it selected for installation / did it install properly, and was it
Blue in AutoPatcher after reboot)?

Also, in a few days rerun APUP to download the new rti file to make 2000 SP4 Official. Of course, this is more cosmetic
than anything, your system will update fine, it's the red Unofficial warning that's nice to remove.

Mike

It is included, and it's in blue after the update.
Also, there is one item listed as MDAC (no kb number) under Updated Components that is always in black, no matter how many times it's been selected to install.

[Cristiano]

mdac doesn't have an kb number, so far i know. can you please try run this one by hand once or post the log for this one in here? the install log shall be at windows folder, with an name like mdac.log. the file is MDAC_TYP.EXE
and the update for it is KB927779

thanks

[]s

[Mark Lloyd]

 Cristiano, on May 18 2009, 10:45 AM, said:

mdac doesn't have an kb number, so far i know. can you please try run this one by hand once or post the log for this one in here? the install log shall be at windows folder, with an name like mdac.log. the file is MDAC_TYP.EXE
and the update for it is KB927779

thanks

[]s

I found the update in (from the AP directory):

modules\Components\__MDAC\KB927779_2K_MDAC_2_8_SP1_enu.apm files\MDAC281-KB927779-x86-ENU.exe

Running this seemed to install it (after an "agreement"). Autopatcher still shows "MDAC" in black. I found what seems to be the log file:

WINNT\MDAC28SP1-KB927779-x86-ENU.log

This forum software won't allow posting it here (says it's too long). It can be found at:

notstupid.us/pix/MDAC28SP1-KB927779-x86-ENU.log

[Cristiano]

in deed, you can't attach in here, but cp works. just put it with (codebox) and (/codebox). just replace ( by [ and ) by ]. you may just to break the post in more than one

in deed, your install seems ok. the issue seems related to an wrong detection. it can be fixed.

thanks

[]s

[_def_x_]

@Mark Lloyd

Can you check your registry for related info for "mdac 2.8 sp1" or "2.81.1128.0"
HKLM\SOFTWARE\Microsoft\DataAccess\...\...\

Microsoft Data Access Components 2.8:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP0\KB927779

Microsoft Data Access Components 2.8 Service Pack 1:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779

And check your system for these files / versions.

Msadco.dll       2.81.1128.0
Msado15.dll      2.81.1128.0
Msadomd.dll      2.81.1128.0
Msadox.dll       2.81.1128.0
Msdasql.dll      2.81.1128.0
Msjro.dll        2.81.1128.0

One of the apm files has this as a detection -> "KeyValue=2.81.1117.6", if you could check your registry to see if this value
is associated with mdac 2.8 sp1, or if it might be an older version of mdac?

The proper detection for MDAC 2.8 SP1 can be found here KB927779, I would be interested in knowing what your system shows
for file versions and registry entries after applying this update?

Here is a utility to check for versions of mdac (requires validation) -> MDAC Utility

Mike

Edited by James, 01 August 2009 - 05:26 PM.
Put file list in code snippet box

[_def_x_]

I wonder if this would work for "KB927779_2K_MDAC_2_8_SP1_enu.apm", this info is taken from the extracted update
inf, and from looking for the files in my 2000 SP4 partition (I can't boot to it anymore), but I did find the updated files
from when I had applied the update way back when. It seems the cat file detection info is correct but isn't working.

...possible new detection scheme
[DetectionRegistry]
RegistryPath=HKLM\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779
KeyName=
KeyValue="maybe we could locate this value and add it"

[DetectionFile]
FilePath=windows:\Program Files\Common Files\System\ado
FileName=msadomd.dll,msjro.dll,msado15.dll,msADOX.dll
FileVersion=2.81.1128.0
FileMD5=

Quote

One of the apm files has this as a detection -> "KeyValue=2.81.1117.6"

This information seems to be correct for "MDAC2_8SP1_enu.apm" according to the extracted inf file.

Mike

[Mark Lloyd]

 gUiTaR_mIkE, on May 18 2009, 02:12 PM, said:

@Mark Lloyd

Can you check your registry for related info for "mdac 2.8 sp1" or "2.81.1128.0"
HKLM\SOFTWARE\Microsoft\DataAccess\...\...\

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess]
"FullInstallVer"="2.81.1128.0"
"Version"="2.81.1117.6"
"Full21Install"=dword:ffffffff
"SavedRollbackVersion"="2.53.6200.1"
"LocVer"="1033"
"RollbackVersion"="2.81.1117.6"
"PatchLevel"="2.81.1128.0"

 gUiTaR_mIkE, on May 18 2009, 02:12 PM, said:

Microsoft Data Access Components 2.8:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP0\KB927779

I did not find any "sp0" section.

 gUiTaR_mIkE, on May 18 2009, 02:12 PM, said:

Microsoft Data Access Components 2.8 Service Pack 1:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779

----------------------------------------

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779]
"PackageName"="MDAC28SP1-KB927779-x86-ENU"
"PackageVersion"="1"
"Publisher"="Microsoft Corporation"
"Publishing Group"="SQL Server"
"ReleaseType"="Hotfix"
"ARPLink"="HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Uninstall\\"
"InstallerName"="Update.exe"
"InstallerVersion"="6.2.24.0"
"ParentDisplayName"="Microsoft Data Access Components"
"InstalledDate"="12/3/2007"
"InstalledBy"="Administrator"
"UninstallCommand"="C:\\WINNT\\$SQLUninstallMDAC28SP1-KB927779-x86-ENU$\\spuninst\\spuninst.exe "
"Type"="Update"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist]

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\0]
"FileName"="SQLSTPCustomDLL.dll"
"Version"="1.4.17.0"
"BuildDate"="Fri Dec 22 12:42:32 2006"
"BuildCheckSum"="2322e8"
"Location"="C:\\WINNT\\$SQLUninstallMDAC28SP1-KB927779-x86-ENU$\\Spuninst"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\1]
"FileName"="SQLSTPCustomDLL.rll"
"Version"="1.4.17.0"
"BuildDate"="Fri Dec 22 12:41:44 2006"
"BuildCheckSum"="1203c"
"Location"="C:\\WINNT\\$SQLUninstallMDAC28SP1-KB927779-x86-ENU$\\Spuninst"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\10]
"FileName"="msjro.dll"
"Version"="2.81.1128.0"
"BuildDate"="Wed Dec 27 12:19:57 2006"
"BuildCheckSum"="2422a"
"Location"="C:\\WINNT\\system32\\DllCache"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\11]
"FileName"="msadco.dll"
"Version"="2.81.1128.0"
"BuildDate"="Wed Dec 27 12:19:18 2006"
"BuildCheckSum"="2de5f"
"Location"="C:\\WINNT\\system32\\DllCache"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\12]
"FileName"="sqlsrv32.dll"
"Version"="2000.85.1128.0"
"BuildDate"="Wed Dec 27 16:28:14 2006"
"BuildCheckSum"="7a1fe"
"Location"="C:\\WINNT\\system32\\DllCache"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\13]
"FileName"="odbcbcp.dll"
"Version"="2000.85.1128.0"
"BuildDate"="Wed Dec 27 12:20:07 2006"
"BuildCheckSum"="d512"
"Location"="C:\\WINNT\\system32\\DllCache"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\14]
"FileName"="msado15.dll"
"Version"="2.81.1128.0"
"BuildDate"="Wed Dec 27 16:27:00 2006"
"BuildCheckSum"="80af7"
"Location"="C:\\Program Files\\Common Files\\System\\ADO"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\15]
"FileName"="msadomd.dll"
"Version"="2.81.1128.0"
"BuildDate"="Wed Dec 27 12:19:59 2006"
"BuildCheckSum"="3327b"
"Location"="C:\\Program Files\\Common Files\\System\\ADO"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\16]
"FileName"="msADOX.dll"
"Version"="2.81.1128.0"
"BuildDate"="Wed Dec 27 12:19:57 2006"
"BuildCheckSum"="32a01"
"Location"="C:\\Program Files\\Common Files\\System\\ADO"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\17]
"FileName"="msjro.dll"
"Version"="2.81.1128.0"
"BuildDate"="Wed Dec 27 12:19:57 2006"
"BuildCheckSum"="2422a"
"Location"="C:\\Program Files\\Common Files\\System\\ADO"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\18]
"FileName"="sqloledb.dll"
"Version"="2000.85.1128.0"
"BuildDate"="Wed Dec 27 16:29:36 2006"
"BuildCheckSum"="85ab2"
"Location"="C:\\Program Files\\Common Files\\System\\OLE DB"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\19]
"FileName"="msdasql.dll"
"Version"="2.81.1128.0"
"BuildDate"="Wed Dec 27 16:23:52 2006"
"BuildCheckSum"="53df5"
"Location"="C:\\Program Files\\Common Files\\System\\OLE DB"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\2]
"FileName"="SQLSE.rll"
"Version"="1.4.17.0"
"BuildDate"="Fri Dec 22 12:41:44 2006"
"BuildCheckSum"="1a17d"
"Location"="C:\\WINNT\\$SQLUninstallMDAC28SP1-KB927779-x86-ENU$\\Spuninst"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\20]
"FileName"="sqlsrv32.dll"
"Version"="2000.85.1128.0"
"BuildDate"="Wed Dec 27 16:28:14 2006"
"BuildCheckSum"="7a1fe"
"Location"="C:\\WINNT\\system32"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist\21]
"FileName"="odbcbcp.dll"
"Version"="2000.85.1128.0"
"BuildDate"="Wed Dec 27 12:20:07 2006"
"BuildCheckSum"="d512"
"Location"="C:\\WINNT\\system32"

-------------------------------------------------

 gUiTaR_mIkE, on May 18 2009, 02:12 PM, said:

And check your system for these files / versions.
Msadco.dll-------2.81.1128.0

C:\WINNT\$SQLUninstallMDAC28SP1-KB927779-x86-ENU$     4/28/2004   2.81.1117.0
C:\WINNT\system32\dllcache                             1/5/2007   2.81.1128.0
C:\Program Files\Common Files\System\msadc             1/5/2007   2.81.1128.0

Msado15.dll-----2.81.1128.0

C:\WINNT\$SQLUninstallMDAC28SP1-KB927779-x86-ENU$     4/28/2004   2.81.1117.0
C:\WINNT\system32\dllcache                             1/5/2007   2.81.1128.0
C:\Program Files\Common Files\System\ado               1/5/2007   2.81.1128.0

Msadomd.dll----2.81.1128.0

C:\WINNT\$SQLUninstallMDAC28SP1-KB927779-x86-ENU$     6/18/2003   2.53.6200.0
C:\WINNT\system32\dllcache                             1/5/2007   2.81.1128.0
C:\Program Files\Common Files\System\ado               1/5/2007   2.81.1128.0

Msadox.dll------2.81.1128.0

C:\WINNT\$SQLUninstallMDAC28SP1-KB927779-x86-ENU$     4/28/2004   2.81.1117.0
C:\WINNT\system32\dllcache                             1/5/2007   2.81.1128.0
C:\Program Files\Common Files\System\ado               1/5/2007   2.81.1128.0

Msdasql.dll-----2.81.1128.0

C:\WINNT\$SQLUninstallMDAC28SP1-KB927779-x86-ENU$     4/28/2004   2.81.1117.0
C:\WINNT\system32\dllcache                             1/5/2007   2.81.1128.0
C:\Program Files\Common Files\System\ado               1/5/2007   2.81.1128.0

Msjro.dll--------2.81.1128.0

C:\WINNT\$SQLUninstallMDAC28SP1-KB927779-x86-ENU$     6/18/2003   2.53.6200.0
C:\WINNT\system32\dllcache                             1/5/2007   2.81.1128.0
C:\Program Files\Common Files\System\ado               1/5/2007   2.81.1128.0

 gUiTaR_mIkE, on May 18 2009, 02:12 PM, said:

One of the apm files has this as a detection -> "KeyValue=2.81.1117.6", if you could check your registry to see if this value is associated with mdac 2.8 sp1, or if it might be an older version of mdac?

I found that in 2 places in the registry, both in here:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DataAccess]
"FullInstallVer"="2.81.1128.0"
"Version"="2.81.1117.6"
"Full21Install"=dword:ffffffff
"SavedRollbackVersion"="2.53.6200.1"
"LocVer"="1033"
"RollbackVersion"="2.81.1117.6"
"PatchLevel"="2.81.1128.0"

 gUiTaR_mIkE, on May 18 2009, 02:12 PM, said:

The proper detection for MDAC 2.8 SP1 can be found here KB927779, I would be interested in knowing what your system shows
for file versions and registry entries after applying this update?

Here is a utility to check for versions of mdac (requires validation) -> MDAC Utility

Mike

Edited by James, 01 August 2009 - 05:53 PM.
Put information in proper codeboxes and reformatted

[_def_x_]

If you are willing to try an experiment, and edit the apm information, try this:

(01) "Copy" (don't "Move") "KB927779_2K_MDAC_2_8_SP1_enu.apm" to a safe place. You will need to put the
file back when we're done (and delete the edited apm).

(02) Now that you have an unedited backup set aside, lets edit the apm in the apup folder -> "KB927779_2K_MDAC_2_8_SP1_enu.apm".
Open the apm in notepad and make the following changes:

Note: We want to determine which detection information works (hopefully both), so lets "Remove" the [DetectionFile] data first, everything
after "=" -> leave the "fields" just "Remove" the data, and "Add" the new [DetectionRegistry] data below. Now that the new [DetectionRegistry]
data has been added, and the [DetectionFile] fields are empty, "Save" (not "Save As") the changes.

(03) Now, run AutoPatcher and see if the [DetectionRegistry] data alone is enough to detect the mdac update - Yes / No?

Now, do the opposite, "Remove" the data from [DetectionRegistry], "Add" the new data to "[DetectionFile]", and "Save" (not "Save As") the changes.
Now, run AutoPatcher again... Was the new [DetectionFile] data alone enough to detect the mdac update - Yes / No?

Finally, what happens when both [DetectionRegistry] and [DetectionFile] fileds are filled in with the new data and AutoPatcher is run?

Note:
- KeyName= and FileMD5= have empty fileds
- Please report what detection worked - appeared Blue in AutoPatcher - None, Both, [DetectionRegistry], [DetectionFile]
- When done, you can Delete the edited apm file and Move the original you set aside back to the proper apup folder.

[DetectionRegistry]
RegistryPath=HKLM\SOFTWARE\Microsoft\Updates\DataAccess\MDAC28\SP1\KB927779\Filelist
KeyName=
KeyValue=2.81.1128.0

[DetectionFile]
FilePath=windows:\Program Files\Common Files\System\ado
FileName=msadomd.dll,msjro.dll,msado15.dll,msadox.dll
FileVersion=2.81.1128.0
FileMD5=

Alternate [DetectionFile] scheme:

[DetectionFile]
FilePath=windows:\WINNT\system32\dllcache
FileName=msadco.dll,msado15.dll,msadomd.dll,msadox.dll,msdasql.dll,msjro.dll
FileVersion=2.81.1128.0
FileMD5=

Mike