Archive: Installing MSDE using NSIS


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.


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.


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.


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!


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

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


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


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?

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?

Thanks.

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


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.


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...


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.

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?