VSTS 2008 could not load file or assembly Interop.SHDocVw

Today I downloaded WatiN (Web application test in .Net) tools and wanted to run the web test using Visual Studio .Net 2008. I got the following error:

Could not load file or assembly 'Interop.SHDocVw, Version=1.1.0.0, Culture=neutral, PublicKeyToken=null' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)

If you see this in the future, it is easy to fix it. You can just go to C:\Windows\System32 and copy shdocvw.dll to the bin directory of your current project.

Open your Visual Studio project, add shdocvw.dll in your references and run the test again. The problem will be disappeared.

Always install SQL Server 2008 RTM first before you install Visual Studio 2008

If you have Visual Studio 2008 and Visual Studio 2008 SP1 Beta on your PC, and then you want to install SQL Server 2008 RTM, you might have the following error.

A previous release of Microsoft Visual Studio 2008 is installed on this computer. Upgrade Microsoft Visual Studio 2008 to the SP1 before installing SQL Server 2008.
(see : http://support.microsoft.com/kb/956139)

That’s because you have Visual Studio 2008 SP1 Beta on your PC, not Visual Studio 2008 SP1. If you don’t have SP1, you can’t install it successfully. Today is August 9, and we need to wait until Microsoft releases Visual Studio 2008 SP1.

If you really want to install SQL Server 2008 RTM now, you need to uninstall Visual Studio 2008 and SP1 , install SQL Server 2008 RTM and then reinstall Visual Studio 2008. When Visual Studio 2008 SP1 is released, you can install it later.

The lesson I learn :
Always install SQL Server 2008 RTM first before you install Visual Studio 2008 +SP1

Microsoft doesn’t support upgrading from SQL Server 2008 RC0 to SQL Server 2008 RTM

If you have SQL Server 2008 RC0 and Visual Studio 2008 SP1 Beta on your PC and then you want to upgrade to SQL Server 2008 RTM, You may feel disappointed.

At this moment, Microsoft doesn’t support upgrading from SQL Server 2008 RC0 to SQL Server 2008 RTM.

You need to uninstall SQL Server 2008 Beta and Visual Studio 2008 SP1 Beta first and then install SQL Server 2008 RTM.

Will it change in the future??

The installation package cannot be installed by the installer service

SQL Server 2008 RTM is released now. Today I used my Windows Server 2008 PC to download SQL Server 2008 Books Online (SQLServer2008_BOL.msi). I tried to install it, but it had the following message.

The installation package cannot be installed by the installer service. You must install a windows service pack that contains a newer version of the windows installer service.

This message showed that I didn’t have Windows Installer. After I installed Windows Installer 4.5 Redistributable (Windows6.0-KB942288-v2-x86.msu), everything was fine.