In the App.config file under <appsettings> how do I bind a DSN name to the value property.
I have tried this
<add key="keyname" value="DSN=dsnname;integrated security=true">
I am getting an error "keyword dsn not supported". I must use the DSN name as the server names may not be the same but the DSN will point to the correct server when the application is moved to the production environment.
I am using the .Net 4.0 Framework.