[Bug 12501] Microsoft SQL Server 2005 Express Edition installer fails due to mspatcha.dll ApplyPatchToFileW being a stub (Microsoft Delta Compression API)

http://bugs.winehq.org/show_bug.cgi?id=12501

Anastasius Focht  changed:

What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |Installer
            Summary|ms sql express 2005 fails   |Microsoft SQL Server 2005
                   |to install                  |Express Edition installer
                   |                            |fails due to mspatcha.dll
                   |                            |ApplyPatchToFileW being a
                   |                            |stub (Microsoft Delta
                   |                            |Compression API)

--- Comment #23 from Anastasius Focht  2012-01-09 13:37:48 CST ---
Hello,

revisiting, refining summary, targeting stub.

--- snip ---
0024:Call KERNEL32.LoadLibraryA(0032f3ec "C:\windows\system32\mspatcha.dll")
ret=010036a5
0024:Call PE DLL (proc=0x20011e30,module=0x20010000
L"mspatcha.dll",reason=PROCESS_ATTACH,res=(nil)) 
...
0024:Call mspatcha.ApplyPatchToFileA(0032fa44
"c:\d5766cdb1e150717cd66ffb31641\_sfx_0000._p",0032fb48
"c:\d5766cdb1e150717cd66ffb31641\Setup\Program Files\Microsoft SQL
Server\x86\Install\sqlagent90_msdb_upgrade.sql",0032fc4c
"c:\d5766cdb1e150717cd66ffb31641\Setup\Program Files\Microsoft SQL
Server\x86\Install\instmsdb.sql",00000000) ret=0100483a 
...
0024:fixme:mspatcha:ApplyPatchToFileW stub -
L"c:\d5766cdb1e150717cd66ffb31641\_sfx_0000._p",
L"c:\d5766cdb1e150717cd66ffb31641\Setup\Program Files\Microsoft SQL
Server\x86\Install\sqlagent90_msdb_upgrade.sql",
L"c:\d5766cdb1e150717cd66ffb31641\Setup\Program Files\Microsoft SQL
Server\x86\Install\instmsdb.sql", 00000000 
...
0024:Ret  mspatcha.ApplyPatchToFileA() retval=00000000 ret=0100483a
0024:Call KERNEL32.GetLastError() ret=0100484e
0024:Ret  KERNEL32.GetLastError() retval=00000078 ret=0100484e
...
--- snip ---

"Delta Compression API"

MSDN: http://msdn.microsoft.com/en-us/library/bb417345.aspx

For the meantime I suggest to add a small, non-intrusive 'winetricks mspatcha'
recipe.
Use "InstMsiA.exe" installer binary from "winetricks msi2" recipe
(http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=...)
and extract only "mspatcha.dll".
Replace mspatcha placeholder and set native override.

This way all installers that require functional mspatcha will work without
having WINEPREFIX tainted too much with other stuff.

Besides native mspatcha, the installer currently needs 'winetricks vcrun2005'
due to msvcp80.dll insufficiency.

$ sha1sum SQLEXPR32.EXE 
edeb3fe40fd6f03087a55b3f4e08bac795f68436  SQLEXPR32.EXE

$ wine --version
wine-1.3.36-172-gb00e703

Regards