How to avoid a service pack installation?

Question

0.00/5 (No votes)

See more:

.NET3.5

, +

I've create a single setup contain my .net application and database which runs in .net3.5 framework.
but here the problem is my application executes only if we install SQLExpress service pack so how to avoid this service pack installation(Service pack is very huge size setup and its taking long time to get the application installed)

Could you please give your suggestion to avoid this long time installation
Ambarish

Posted 16-Apr-11 21:38pm

ambarishtv

Updated 16-Apr-11 21:55pm

Sandeep Mewara

v2

Add a Solution

Comments

OriginalGriff 17-Apr-11 5:32am

Answer updated

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-04-16T22:38:00

If you use MSSQL in your application, then your user must have access to SQL Server to use it. However, it is not normal to ship SQL Express with your app setup - the user may already have SQL Server installed on an existing computer.

If this is a single user database system, consider not using SQL Server. If you use SqlCE instead, the code for the database is included in the .NET framework so no additional installation is required. SqlCE is a cut down version of MsSql which is single user only, and does not support some of MsSql more advanced features.

"Here im using SQL Express 2005(.mdf)database.
When i Installed both SQlCE and my .net application and my application is showing an error "An error has
occured while establising a connnection to the server.when connecting to sql server 2005....error-26
error locating server/Instance specified"
Please give ur advice"

I'm not sure what you have tried to do here: SQLCE won't open a .MDF database: convert it to an SQLCE database instead if you are going to go that route. There is a utility here to do that: SQL Server to SQL Server Compact Edition Database Copy Utility[^]