Hi, I have previously determined if a local SQL server instance is installed by enumerating the REG_MULTI_SZ value HKLM\Software\Microsoft\Microsoft SQL Server\InstalledInstances
Beyond that any further SQL instance specific setup/checking I have performed thru WMI. This approach has worked for both 32 or 64-bit SQL server editions. Do you specifically need to know the edition or not care? Regards, Rob. -----Original Message----- From: Christopher Painter [mailto:chr...@deploymentengineering.com] Sent: 16 September 2011 07:33 To: General discussion for Windows Installer XML toolset.; wix-users@lists.sourceforge.net Subject: Re: [WiX-users] How to detect a x64 SQL Server with a x32 wix setup Maybe I'm missing something but I get nervous checking the registry to find out something about a sql server instance. Perhaps the server isn't even on the machine I'm installing to. I've been known to put connection dialogs in an installer just to validate a connection and write settings out to an app.config. So I do an executescalar query to check the Edition server property and see if it contains the text "64-bit" http://msdn.microsoft.com/en-us/library/ms174396.aspx Maybe I'm missing something though. ---------------------------------------- From: "Graf Jeremy AVL/GRZ" <jeremy.g...@avl.com> Sent: Friday, September 16, 2011 1:16 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] How to detect a x64 SQL Server with a x32 wix setup Hi, in my setup I try to find an installed SQL Server instance and write a connection file with a custom action. This is working fine with an x32 SQL server, but it doesn't find a x64 version. I tried to debug this and the path for the registry entry is right, but it seems that he cannot read the information of this path. Thanks for your help BR Jeremy ________________________________________________________________________ ____ _____________ AVL List GmbH, Firmensitz: Graz, Firmenbuchnummer: FN 53507M, Landesgericht fuer ZRS Graz ------------------------------------------------------------------------ ---- -- BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA http://p.sf.net/sfu/rim-devcon-copy2 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ------------------------------------------------------------------------ ------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA http://p.sf.net/sfu/rim-devcon-copy2 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ******************************************************** The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the addressee, any disclosure, reproduction, copying, distribution, or other dissemination or use of this communication is strictly prohibited. If you have received this transmission in error please notify the sender immediately and then delete this e-mail. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard copy version. ******************************************************** ------------------------------------------------------------------------------ BlackBerry® DevCon Americas, Oct. 18-20, San Francisco, CA http://p.sf.net/sfu/rim-devcon-copy2 _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users