Our product needs to install the SQL Server 2005 Backward compatibility pack. So we have a prerequisite for that. One for the x64 and one for the x86 version of the pack.
The problem is determining if the pack is already installed. There are multiple versions of the pack and each version is identified by a different GUID in HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Installer\Products\{Some GUID}. I've googled this problem and looked at different versions of Windows we have installed and identified 6 different GUIDs for the pack so far. I'm sure I won't be able to find all the different GUIDs.
What I would like to do is use vbscript to see if the pack is installed. I've tested a script that does this and it works across different OSes. But it looks like there is no way to define a search that would test a global property to see if the script detected the pack. Any ideas on how best to deal with this problem?
We are using AI 8.3. We need to support XP, Vista, Windows 7, and Windows Server versions from 2003 upwards, both x86 and x64.
Thanks