How to change connection string in VSTO setup project

Question

Hi,

I have created one Exceladdin using VSTO 2010 option and  populating a forecasting report  in excel by using a database. for that i have used app.config file and configured a connection string.

my problem is after creating a setup (using publish option) i can not change connection string since its throwing below issue

"System.Deploymeny.Application.InvalidDeploymentException:File,ExcelAddIn.dll.config,has a different computed hash than specified in manifest."

Is there any way to change connection string after creating a setup project since we need to change connection string in diff Env accordingly.

Any help will be appreciated.

---

cpsingh

Answer 1

You can specify that the config file will not be hashed during the Publish.

In the properties of your project, select "Publish", then "Application Files". Specify Hash exclude.

This way you can modify the app.config file before the setup.

Answer 2

Thaks Sygrien for reply..

but in my case "Application files" button is not avilable under publish .. seems like in VSTO  projects its not applicable.





---

cpsingh

Answer 3

If you will be publishing with Click Once, and you might need to run Mage to update your manifest with the new hashes. Here's a video explaining the process :-

http://channel9.msdn.com/Blogs/funkyonex/Resigning-ClickOnce-Application-and-Deployment-Manifests-with-MAGE

Answer 4

Its looks like perfect solution.

thanks a ton the help.

 

---

cpsingh