473,372 Members | 1,058 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

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
3 2514
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Bob Reynolds | last post by:
Hello, I have a requirement to create EAR and WAR packages without using the integrated package building tools built into the IDE. The packages will be created via a deployment script,...
5
by: Igor Solodovnikov | last post by:
Hi. I am trying to automatically backup transaction log when error 9002 happened. So i have created appropriate job and alert to catch this error. I have two instances of sql server under Windows...
6
by: Dan Webb | last post by:
Hi All, Im currently working on ways of pacakaging javascript functions/variables/objects in a similar way to the Java package statement so that scripts can be interact with each other with the...
19
by: Blair Adamache | last post by:
IBM is hosting a user focus session to get feedback on a new design concept for installing software products and maintenance. The information below gives a brief summary of the information about...
1
by: Paul Aspinall | last post by:
Hi I have a C# Winform app which runs using SQL Server. I want to package up the app, so that it deploys with MSDE. Can anyone offer any pointers or references to help?? Thanks
15
by: John Nagle | last post by:
I've been installing Python and its supporting packages on a dedicated server with Fedora Core 6 for about a day now. This is a standard dedicated rackmount server in a colocation facility,...
5
by: Paul Rubin | last post by:
I've been through this kind of thing a few times in the past and received excellent advice here on clpy about how to deal with specific technical aspects (e.g. how to use setuptools, InnoSetup,...
60
by: jim | last post by:
I am looking for an application that will wrap my .Net application (and any needed .Net parts) into a single exe. I know of Thinstall ($4,000 for application and per copy fees for your exes) and...
1
by: SPE - Stani's Python Editor | last post by:
Hi All, If you wrote some python code that you want to package or know a cool python application of which you like to make a deb installer, the python packaging session is all for you! Do you...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.