MDAC 2.8 Detection
Mark Lloyd
18 May 2009
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
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
18 May 2009
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
and the update for it is KB927779
thanks
[]s
Mark Lloyd
18 May 2009
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
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
18 May 2009
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
in deed, your install seems ok. the issue seems related to an wrong detection. it can be fixed.
thanks
[]s
_def_x_
18 May 2009
@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.
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.
Reason for edit:: Put file list in code snippet box
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.
Reason for edit:: Put file list in code snippet box
_def_x_
18 May 2009
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=
This information seems to be correct for "MDAC2_8SP1_enu.apm" according to the extracted inf file.
Mike
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"
Mike
Mark Lloyd
19 May 2009
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\...\...\
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
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
---------------------------------------- [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
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
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.
Reason for edit:: Put information in proper codeboxes and reformatted
_def_x_
19 May 2009
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
(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
