The entry '' has already been added error
asp.netasp.net Problem Overview
I have a web.config in ASP.net giving me configuration error.
<connectionStrings>
<add name="conn1" connectionString="Data Source=test;database=test;uid=test;pwd=test"/>
<add name="conn2" connectionString="Data Source=123.123.1.123;database=test2;uid=test;pwd=test"/>
...
It throws "The entry 'conn2' has already been added." error. I know I only added it once. Not sure what it is wrong with.
asp.net Solutions
Solution 1 - asp.net
it can be in web.config that is parent to this one. just add
<remove name="conn2" />
before your add it (again) :)
alternatively clear all connection string using
<clear />
Solution 2 - asp.net
You should use <clear />
when adding any providers to your web.config. Read this article: http://weblogs.asp.net/scottgu/archive/2006/11/20/common-gotcha-don-t-forget-to-clear-when-adding-providers.aspx
> The root cause of the above problem rests in how the new provider was
> registered within the web.config file.
>
> The
If you have another project using the same connection string name you will receive this error because that connection string has already been added to the collection.
Solution 3 - asp.net
If you override the ToString() method then this will work. Looks like the configuration mechanism uses that to check if something already exists in the collection
Solution 4 - asp.net
I got this error and the issue turned out to be a web.config deployed to the root of the domain