467,074 Members | 1,069 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,074 developers. It's quick & easy.

Packaging MSDE in with Winforms C# app, using Windows packages

Hi
I want to package my C# winforms app, to be deployed with MSDE, as easily as
possible for the end user.

I want to create an MSI or Installshield (prefer MSI), to setup my C# app,
together with MSDE (if not already installed), and the MSDE application DB.

How can I detect if MSDE is already installed??

Has anyone does this?? How??

Thanks
Paul
Nov 16 '05 #1
  • viewed: 2252
Share:
3 Replies
Merge Modules:
http://www.sqljunkies.com/Article/48...2CA762ED6.scuk

ok,
aq

"Paul Aspinall" <pa**@aspy.co.uk> wrote in message
news:h9****************@fe3.news.blueyonder.co.uk. ..
Hi
I want to package my C# winforms app, to be deployed with MSDE, as easily as possible for the end user.

I want to create an MSI or Installshield (prefer MSI), to setup my C# app,
together with MSDE (if not already installed), and the MSDE application DB.
How can I detect if MSDE is already installed??

Has anyone does this?? How??

Thanks
Paul

Nov 16 '05 #2
In message <h9****************@fe3.news.blueyonder.co.uk>, Paul Aspinall
<pa**@aspy.co.uk> writes
Hi
I want to package my C# winforms app, to be deployed with MSDE, as easily as
possible for the end user.

I want to create an MSI or Installshield (prefer MSI), to setup my C# app,
together with MSDE (if not already installed), and the MSDE application DB.

How can I detect if MSDE is already installed??

Has anyone does this?? How??


Everything I have found on the subject of packaging MSDE in your own MSI
or InstallShield package says "Just Don't Do It". It has many with
problems to deal with. This really only leaves two choices.

1. Include the standard MSDE package on your CD (or other Distribution
Media) and provide installation instructions which tell the user how to
install MSDE if required (remember the user might already have MSDE or
SQL Server installed and prefer to use that instance). In addition, you
would then need to provide a little setup / configuration program (or
embed it in your application) to Create the Database and associated
Tables etc. Obviously, this is a long winded method and can create
plenty of support calls / emails from the non computer literate.

2. The preferred method is to use the MSDE / SQL Server Deployment
Toolkit available for free download from MSDN. The includes a C# and
VB.Net examples plus full instructions to install (MSDE) and deploy your
database. This new customised package can then be called from your main
/ normal MSI or InstallShield package during the installation process.

I believe method 2 also can detect an existing instance to abort the
installation or install under a new named instance.

As for detecting whether MSDE is already installed (ie: if using method
1 above), I think the simplest way would be to add a Custom Action to
your MSI / InstallShield package to check the existence of several know
registry keys under HKLM and HKCU.

--
Andrew D. Newbould E-Mail: ne********@NOSPAMzadsoft.com

ZAD Software Systems Web : www.zadsoft.com
Nov 17 '05 #3
Thanks for the reply.

I have now resolved this issue very satisfactorily.
MS have a Deployment Toolkit for MSDE, that plugs directly in to Visual
Studio. This provides an easy to use way of packaging your app with MSDE,
and it works great.

I would recommend anyone who has any issues or problems with this, to try
using the MSDE Deployment Toolkit.

http://www.microsoft.com/downloads/d...DisplayLang=en

Thanks
Paul Aspinall

"Andrew D. Newbould" <ne********@NOzadSPANsoft.com> wrote in message
news:N4**************@zadsoft.gotadsl.co.uk...
In message <h9****************@fe3.news.blueyonder.co.uk>, Paul Aspinall
<pa**@aspy.co.uk> writes
Hi
I want to package my C# winforms app, to be deployed with MSDE, as easily
as
possible for the end user.

I want to create an MSI or Installshield (prefer MSI), to setup my C# app,
together with MSDE (if not already installed), and the MSDE application
DB.

How can I detect if MSDE is already installed??

Has anyone does this?? How??


Everything I have found on the subject of packaging MSDE in your own MSI
or InstallShield package says "Just Don't Do It". It has many with
problems to deal with. This really only leaves two choices.

1. Include the standard MSDE package on your CD (or other Distribution
Media) and provide installation instructions which tell the user how to
install MSDE if required (remember the user might already have MSDE or SQL
Server installed and prefer to use that instance). In addition, you would
then need to provide a little setup / configuration program (or embed it
in your application) to Create the Database and associated Tables etc.
Obviously, this is a long winded method and can create plenty of support
calls / emails from the non computer literate.

2. The preferred method is to use the MSDE / SQL Server Deployment
Toolkit available for free download from MSDN. The includes a C# and
VB.Net examples plus full instructions to install (MSDE) and deploy your
database. This new customised package can then be called from your main /
normal MSI or InstallShield package during the installation process.

I believe method 2 also can detect an existing instance to abort the
installation or install under a new named instance.

As for detecting whether MSDE is already installed (ie: if using method 1
above), I think the simplest way would be to add a Custom Action to your
MSI / InstallShield package to check the existence of several know
registry keys under HKLM and HKCU.

--
Andrew D. Newbould E-Mail: ne********@NOSPAMzadsoft.com

ZAD Software Systems Web : www.zadsoft.com

Nov 17 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Bob Reynolds | last post: by
5 posts views Thread by Igor Solodovnikov | last post: by
1 post views Thread by Paul Aspinall | last post: by
5 posts views Thread by Paul Rubin | last post: by
1 post views Thread by SPE - Stani's Python Editor | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.