Solved

Application Deployment

Posted on 2007-11-20
4
177 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
  • 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 100

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
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 used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now