Solved

Application Deployment

Posted on 2007-11-20
4
183 Views
Last Modified: 2013-11-26
I have written an application in Visual Studio 2005 using visual basic.  I has Crystal Reports in it and use ODBC connections to access a database.  I would like to publish/deploy this to a file server and have my users run the exe from there.   I want to do it this way so I don't have to install the Crystal Reports runtime, ODBC connections, and updates on each user's local workstation.  Is it possible and if so how can I do this??
0
Comment
Question by:PEAKTT
[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
4 Comments
 
LVL 18

Expert Comment

by:jcoehoorn
ID: 20322324
There is a security feature in the .Net runtime that will limit how it can execute code.  You'll find you have a hard time allowing the .exe file to 'live' on a remote file server.  To get around this, try using the ClickOnce deployment option in visual studio.  This will create in install program that can live on the file server.  You can create a link users can click that will check the install program first, install or update the program if needed, and then run the program locally.  This won't completely get around installing the runtime on the users machine, but should make it possible to automate most of that process.
0
 

Author Comment

by:PEAKTT
ID: 20323606
So what you are saying is....
Publish to the file server as a ClickOnce deployment
Put the ODBC on the local machines and then have the install do the Crystal Report dlls and exe to the local machine.
To run the program, the user will click on the setup.exe on the fileserver to check for updates and it will run locally.
0
 
LVL 18

Accepted Solution

by:
jcoehoorn earned 400 total points
ID: 20323849
That's pretty close.  From the users' perspective they don't even know they're doing an install first- the shortcut for installing the program and running the program is identical, and the install, while not exactly silent, can be very unobtrusive.  It should be able to handle deploying the crystal dlls.

You might be able to improve on this even further.  Depending on your database you can probably eliminate the need for the odbc step completely by using a more native driver, and get a slight speed boost as a bonus.
0
 
LVL 101

Assisted Solution

by:mlmcc
mlmcc earned 100 total points
ID: 20324567
This link should provide the Click Once deployment steps and file requirements for Crystal
http://www.businessobjects.com/global/pdf/dev_zone/VS2005_Walkthroughs.pdf

mlmcc
0

Featured Post

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

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

The object model of .Net can be overwhelming at times – so overwhelming that quite trivial tasks often take hours of research. In this case, the task at hand was to populate the datagrid from SQL Server database in Visual Studio 2008 Windows applica…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

718 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