?
Solved

Application Deployment

Posted on 2007-11-20
4
Medium Priority
?
184 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 1600 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 400 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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
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…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

762 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