Re: [WiX-users] Detecting Which version of SQL is installed
is this a .net 2.0 product? If so, can't you package the .mdf and .ldf sql database log files with your app and use the new connection string options on the System.Data.SqlClient to point to the database files and use those as your sql database instead of needing an installed instance? lower performance...but this is a demo version right? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Frank Eden Sent: Saturday, November 24, 2007 10:05 PM To: wix-users@lists.sourceforge.net Subject: Re: [WiX-users] Detecting Which version of SQL is installed Thanks for the prompt replies, much appreciated. I guess I should have mentioned why I wanted to install a database and why I wanted to avoid user interaction if possible, and that is because i want to install a 'demo' which just works out of the box. The more questions I ask, the more intimidating is that first impression. Fairly obviously I have a dependency on SQLserver for this demo, and thats bad enough, since it means I will probably have to have a SETUP.exe bootstrapper that installs SQLserverExpress if it or SQlserver isnt installed already. As for installing on a different machine somewhere, I will give that some thought, that would mean the customer doesnt need to have either installed on theiir machine, so there is some value in that. As Malcolm Fraser (a former Australian Prime Minister) once said Life isnt meant to be easy. -- View this message in context: http://www.nabble.com/Detecting-Which-version-of-SQL-is-installed-tf4867935. html#a13932244 Sent from the wix-users mailing list archive at Nabble.com. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
[WiX-users] Detecting Which version of SQL is installed
I am installing a database on the target machine using SqlDatabase My difficulty is that I do not know whether the end-user has SQLExpress or SQL installed, so I dont know whether to use Server='[%COMPUTERNAME]\SQLEXPRESS' or Server='[%COMPUTERNAME]' Im thinking I should be able to detect which is installed, set a variable, then use that variable, something like Server='[%COMPUTERNAME][SQL]' Any ideas on how to do this? -- View this message in context: http://www.nabble.com/Detecting-Which-version-of-SQL-is-installed-tf4867935.html#a13929956 Sent from the wix-users mailing list archive at Nabble.com. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Detecting Which version of SQL is installed
I would guess you'd have to write a custom action to investigate what they had installed and set it to a variable (like you suggested). However, just because someone has Sql Server or Sql Express doesn't guarantee that it will just be [COMPUTERNAME] or [COMPUTERNAME]\SQLEXPRESS. You can install either of those products to any name you want. On Nov 24, 2007 4:15 PM, Frank Eden [EMAIL PROTECTED] wrote: I am installing a database on the target machine using SqlDatabase My difficulty is that I do not know whether the end-user has SQLExpress or SQL installed, so I dont know whether to use Server='[%COMPUTERNAME]\SQLEXPRESS' or Server='[%COMPUTERNAME]' Im thinking I should be able to detect which is installed, set a variable, then use that variable, something like Server='[%COMPUTERNAME][SQL]' Any ideas on how to do this? -- View this message in context: http://www.nabble.com/Detecting-Which-version-of-SQL-is-installed-tf4867935.html#a13929956 Sent from the wix-users mailing list archive at Nabble.com. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Detecting Which version of SQL is installed
I think the generally preferred way of handling this is one of: (1) provide a list of SQL server instances on the machine and allow the user to choose which instance to install to (2) default to [COMPUTERNAME] as the instance name, and allow the user to override the choice on the command line of msiexec, or in a dialog if running in UI mode. (3) don't install to SQL, provide scripts for the SQL setup and require the administrator to run the SQL scripts for the configuration of the database. I personally like #3 for server-based products (web sites, etc.) since it allows the administrator to choose where to install the database objects (for instance on another server altogether, etc.) and #2 for desktop-based products (except perhaps assume SQLEXPRESS as the default for desktop-based products). Perhaps my preference for #3 is due to my Oracle background and how it's much easier to make installs that are NOT touching the DB directly (plus Oracle DBAs tend to be much more fussy about topography of their databases, instances, etc., at least the ones I've known). In any case, I feel it gives the best of all situations, except that the administrator has to do a bit more work in exchange for this flexibility. Kelly Ben Reichelt [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/24/2007 02:42 PM To Frank Eden [EMAIL PROTECTED] cc wix-users@lists.sourceforge.net Subject Re: [WiX-users] Detecting Which version of SQL is installed I would guess you'd have to write a custom action to investigate what they had installed and set it to a variable (like you suggested). However, just because someone has Sql Server or Sql Express doesn't guarantee that it will just be [COMPUTERNAME] or [COMPUTERNAME]\SQLEXPRESS. You can install either of those products to any name you want. On Nov 24, 2007 4:15 PM, Frank Eden [EMAIL PROTECTED] wrote: I am installing a database on the target machine using SqlDatabase My difficulty is that I do not know whether the end-user has SQLExpress or SQL installed, so I dont know whether to use Server='[%COMPUTERNAME]\SQLEXPRESS' or Server='[%COMPUTERNAME]' Im thinking I should be able to detect which is installed, set a variable, then use that variable, something like Server='[%COMPUTERNAME][SQL]' Any ideas on how to do this? -- View this message in context: http://www.nabble.com/Detecting-Which-version-of-SQL-is-installed-tf4867935.html#a13929956 Sent from the wix-users mailing list archive at Nabble.com. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users ** This communication is intended solely for the addressee and is confidential. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Unless indicated to the contrary: it does not constitute professional advice or opinions upon which reliance may be made by the addressee or any other party, and it should be considered to be a work in progress. Unless stated otherwise, this communication does not form a prescribed statement of actuarial opinion under American Academy of Actuaries guidelines. **- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
Re: [WiX-users] Detecting Which version of SQL is installed
Thanks for the prompt replies, much appreciated. I guess I should have mentioned why I wanted to install a database and why I wanted to avoid user interaction if possible, and that is because i want to install a 'demo' which just works out of the box. The more questions I ask, the more intimidating is that first impression. Fairly obviously I have a dependency on SQLserver for this demo, and thats bad enough, since it means I will probably have to have a SETUP.exe bootstrapper that installs SQLserverExpress if it or SQlserver isnt installed already. As for installing on a different machine somewhere, I will give that some thought, that would mean the customer doesnt need to have either installed on theiir machine, so there is some value in that. As Malcolm Fraser (a former Australian Prime Minister) once said Life isnt meant to be easy. -- View this message in context: http://www.nabble.com/Detecting-Which-version-of-SQL-is-installed-tf4867935.html#a13932244 Sent from the wix-users mailing list archive at Nabble.com. - This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse012070mrt/direct/01/ ___ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users