yoda77ni yoda77ni - 7 months ago 17
SQL Question

Webconfig file not formed correclty

On my live box I am getting an error that the connection string is malformerd but when i try it on my dev box it is fine.


<add name="aperturenetEntities" connectionString="metadata=res://*/ApertureModel.csdl|res://*/ApertureModel.ssdl|res://*/ApertureModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=APR-AZ-DB01;initial catalog=aperturenet;user id=aperturenet;password=dw13£sowwoq;multipleactiveresultsets=True;application name=EntityFramework&quot;" providerName="System.Data.EntityClient" />
<add name="aperturenetSql" connectionString="Data Source=APR-AZ-DB01;database=aperturenet;User ID=username;Password=password" providerName="System.Data.SqlClient" />



They are both .net 4.5 boxes with no difference in sql version of the driver but yet i get malformed elements when running the application any idea?.

Answer
<add name="aperturenetEntities" connectionString="metadata=res://*/ApertureModel.csdl|res://*/ApertureModel.ssdl|res://*/ApertureModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=APR-AZ-DB01;initial catalog=aperturenet;user id=aperturenet;password=dw13£sowwoq;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

try this, i have changed Application Name to App in your connection string.