usually I would create another config file and change the connction string loaction with config source attribute, but I can't do it here. Is there any way I can do this?
Thanks, won't this will force me to move all my appSettings to this file? I don't know if one of the extentions that I am using or will install will need this appSetting section and it will fail.
No, you can have the connection string in the AppSettings.config, and the rest of the AppSettings config values remain in the web.config. Any value in the external file will override the web.config values if the value exists in both.
Changing the connection string location
Hi
I see that the connection string is located in the Web.Config file under:
<appSettings>
<add key="umbracoDbDSN" value="data source=ORAN-PC\SQLEXPRESS;integrated security=True;persist security info=False;initial catalog=ActivenetDB" />
</appSettings>
usually I would create another config file and change the connction string loaction with config source attribute, but I can't do it here. Is there any way I can do this?
Still need some help with this :( if any one has any pointers for me it'll be great.
hi Moran
You can put the AppSettings config items in an external file by adding the file attribute to the appSettings element.
For example
<appSettings file="appSettings.config"> <-- UmbracoDbDSN in external file --> <add key="umbracoConfigurationStatus" value="4.7.1.1"/> etcThe appSettings.config file will then look like
<?xml version="1.0"?> <appSettings> <add key="umbracoDbDSN" value=" --Connection String-- "/> </appSetting>Dallas
Thanks, won't this will force me to move all my appSettings to this file? I don't know if one of the extentions that I am using or will install will need this appSetting section and it will fail.
No, you can have the connection string in the AppSettings.config, and the rest of the AppSettings config values remain in the web.config. Any value in the external file will override the web.config values if the value exists in both.
http://code.commongroove.com/2007/09/28/override-appsettings-with-the-file-attribute/
Thanks man this is what I have been searching for :)
is working on a reply...