?
Solved

VS2010 package and deploy with prerequisites

Posted on 2013-11-12
3
Medium Priority
?
373 Views
Last Modified: 2013-11-20
I'm looking for some advice (and links if necessary) on how to package a VB.Net application that requires also installing Crystal Reports and SQL Server on the clients machine.  Is the VS package and deployment utility enough or do I need to use a 3rd party like Installwise or Installshield?

My current deployment project errors if Crystal Reports isn't already installed on the target machine.  I have to manually run the CR installation and then restart my application installation.  I would like the install to check for and install CR automatically as needed.

Also, SQL Express has to be installed manually, I would also like my install to check for and install SQL Express as necessary.

Finally, the SQL Express install takes quite a long time and is more difficult than most end-users can handle on their own as it requres instance naming, permission setting, running scripts etc.  I'm sure this can be configured to make it easier on the end user, but I don't know how.  Is there a smaller easier to install version of SQL that would work for a back end but is capable of addressing the permissions and script running issues?

In short, I want to know if I can have a single setup.exe that will install my app, CR and SQL (with configuration settings) that is simple enough for any end user to install themselves.

Thank you for your help.
0
Comment
Question by:PSCTECH
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39642753
You need to include the runtimes for Crystal.

I assume you are using the version of Crystal that comes with VS2010.  The runtimes are available here

http://scn.sap.com/docs/DOC-7824

mlmcc
0
 

Author Comment

by:PSCTECH
ID: 39642793
I have the runtime included (yes it's the version that comes with VS2010) but my install is not checking and installing, it's just erroring out.  Also, I have all of the SQL issues too.
0
 
LVL 101

Accepted Solution

by:
mlmcc earned 2000 total points
ID: 39642863
From the SAP/Crystal website

Install the Visual Studio 2005 Service Pack 1 ATL Security Update
Add the Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package ATL Security Update to your setup project

http://www.sdn.sap.com/notes?id=0001531409&boj=/sap/bc/bsp/spn/scn_bosap/notes.do?access=69765F6D6F64653D3939382669765F7361706E6F7465735F6E756D6265723D30303031353331343039

mlmcc
0

Featured Post

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question