Installing MSDE using NSIS

PadmanabaPrasad · 20th December 2005, 05:31

Hi All,

I need to install MSDE along with my code,
as NSIS doesn't support MSI/Merge Module
type of installtion.

I tried doing it Programatically using
SQL-DMO but its only an administrative library.

Please any one suggest how to Install MSDE
using NSIS.

Thanks in Advance.

Prasad.

SeanB · 20th December 2005, 05:56

Hi

I've just recently done this. Basically what I did is check the registry to see what (if any) instances of MSDE were installed. I require a particular instance, but if you don't then you can use my script with the instance name of MSSQLSERVER which is the default instance.

You may have to adjust the script slightly to suit your needs, but I'm sure it'll give you a good enough idea.

Script attached.

PadmanabaPrasad · 20th December 2005, 08:04

Thank You !!!!!

I have a small Issues in bundling
the MSDE setup, its size is 70 MB.
so my Application size will
increase drastically.
If i do the same thing with install shield
it comes to 23 MB (MSDE+ Application).

Please suggest any optimal solution.

SeanB · 20th December 2005, 09:05

Sorry, can't help you with that. I distribute my software by CD, and so it's easier for me to put MSDE on the CD itself and not make it part of the setup.exe.

You could detect it and download it if required, but then you'd have to be sure that your end user has an internet connection, and not dial up!

PadmanabaPrasad · 20th December 2005, 13:15

Thanks for all your suggestions !!!!
:-)

Final clarification,
will NSIS support MSI/ Merge module in
Future Releases ???

kichik · 20th December 2005, 17:56

Maybe, but certainly not in the near future. For now, you execute msiexec.exe to install MSI or merge modules.

21st December 2005, 04:54

Quote:

Originally posted by PadmanabaPrasad
Thank You !!!!!

I have a small Issues in bundling
the MSDE setup, its size is 70 MB.
so my Application size will
increase drastically.
If i do the same thing with install shield
it comes to 23 MB (MSDE+ Application).

Please suggest any optimal solution.

Have you tried using 7Zip to compress MSDE setup?

Also, why MSDN and not the new SQL Server 2005 Express Edition?

21st December 2005, 04:55

Quote:

Originally posted by kichik
Maybe, but certainly not in the near future. For now, you execute msiexec.exe to install MSI or merge modules.

What would be required to support them? A rearchitecture of NSIS, a plug-in, or other?

PadmanabaPrasad · 21st December 2005, 04:56

Thanks.

I will use 'msiexec' that suits best
for my requirement ;-)

PadmanabaPrasad · 21st December 2005, 05:37

We tried using the 7-Zip
but even then the size doesn't
vary.And SQL Server 2005 Express Edition
requires ".Net framework" to be installed.

Actully we want the application to be run
independent of .Net/ JRE.

Fretje · 22nd December 2005, 09:24

Small question regarding the commandline parameters of the setup:
What exactly means /qr+ ? And where have you found that?
I have searched a lot on google, and all I can find was
/qn (don't show any user interface) and /qb (show only basic interface)

Also: Where did you find about that return value 8192?
I found this site:

http://msdn.microsoft.com/library/de...rror_codes.asp

which tells a lot about errors, but never number 8192...

I ask this because when installing on xp or server2k3, there's not always a reboot requirement... So I want to check for it before I set the RebootFlag in NSIS...

kichik · 22nd December 2005, 16:28

Quote:

Originally posted by MikeSchinkel
What would be required to support them? A rearchitecture of NSIS, a plug-in, or other?

I don't know what exactly it'd take, as I haven't looked too deeply into it. But I do know that it would surely take way more than a plug-in. At minimum, it'd require an abstraction of every writing method so that creating both self-contained executables and MSI packages is supported.

govmust · 21st August 2007, 13:29

Hi all,

I've tried using code made by SeanB but to no avail. I keep getting an error Invalid command: registry::Read

I've included d/l-ed Registry plugin from http://nsis.sourceforge.net/Registry_plug-in and made
!include "Registry.nsh" in my script.
I'm using nsis 2.29
Anyone having ideas?

20th December 2005, 05:31	#1
PadmanabaPrasad Junior Member Join Date: Dec 2005 Location: Chennai,India Posts: 5	Installing MSDE using NSIS Hi All, I need to install MSDE along with my code, as NSIS doesn't support MSI/Merge Module type of installtion. I tried doing it Programatically using SQL-DMO but its only an administrative library. Please any one suggest how to Install MSDE using NSIS. Thanks in Advance. Prasad.

20th December 2005, 17:56	#6
kichik M.I.A. [NSIS Dev, Mod] Join Date: Oct 2001 Location: Israel Posts: 11,343	Maybe, but certainly not in the near future. For now, you execute msiexec.exe to install MSI or merge modules. NSIS FAQ \| NSIS Home Page \| Donate $ "I hear and I forget. I see and I remember. I do and I understand." -- Confucius

22nd December 2005, 09:24	#11
Fretje Junior Member Join Date: Nov 2005 Posts: 13	Small question regarding the commandline parameters of the setup: What exactly means /qr+ ? And where have you found that? I have searched a lot on google, and all I can find was /qn (don't show any user interface) and /qb (show only basic interface) Also: Where did you find about that return value 8192? I found this site: http://msdn.microsoft.com/library/de...rror_codes.asp which tells a lot about errors, but never number 8192... I ask this because when installing on xp or server2k3, there's not always a reboot requirement... So I want to check for it before I set the RebootFlag in NSIS... Last edited by Fretje; 22nd December 2005 at 10:19.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

20th December 2005, 08:04	#3
PadmanabaPrasad Junior Member Join Date: Dec 2005 Location: Chennai,India Posts: 5	Thank You !!!!! I have a small Issues in bundling the MSDE setup, its size is 70 MB. so my Application size will increase drastically. If i do the same thing with install shield it comes to 23 MB (MSDE+ Application). Please suggest any optimal solution.

20th December 2005, 09:05	#4
SeanB Junior Member Join Date: Dec 2005 Posts: 12	Sorry, can't help you with that. I distribute my software by CD, and so it's easier for me to put MSDE on the CD itself and not make it part of the setup.exe. You could detect it and download it if required, but then you'd have to be sure that your end user has an internet connection, and not dial up!

20th December 2005, 13:15	#5
PadmanabaPrasad Junior Member Join Date: Dec 2005 Location: Chennai,India Posts: 5	Thanks for all your suggestions !!!! :-) Final clarification, will NSIS support MSI/ Merge module in Future Releases ???

21st December 2005, 04:56	#9
PadmanabaPrasad Junior Member Join Date: Dec 2005 Location: Chennai,India Posts: 5	Thanks. I will use 'msiexec' that suits best for my requirement ;-)

21st December 2005, 05:37	#10
PadmanabaPrasad Junior Member Join Date: Dec 2005 Location: Chennai,India Posts: 5	We tried using the 7-Zip but even then the size doesn't vary.And SQL Server 2005 Express Edition requires ".Net framework" to be installed. Actully we want the application to be run independent of .Net/ JRE.

21st August 2007, 13:29	#13
govmust Junior Member Join Date: Aug 2007 Posts: 11	Hi all, I've tried using code made by SeanB but to no avail. I keep getting an error Invalid command: registry::Read I've included d/l-ed Registry plugin from http://nsis.sourceforge.net/Registry_plug-in and made !include "Registry.nsh" in my script. I'm using nsis 2.29 Anyone having ideas?