unable to connect database using ADO Dot Net Entity Data Model when
website is hosted in IIS
i am using ADO Dot Net Entity Data Model (.edmx) approach in my
website.it's working fine in local system but i when i hosted this
application in IIS, i am not able to connect database ,i mean problem in
my server connection string.please let me know how to resolve this issue
and how to make sure myself my server connection string is validated.
this is my local system connection string
<add name="myconnectionstring"
connectionString="metadata=res://*/App_Code.db.csdl|res://*/App_Code.db.ssdl|res://*/App_Code.db.msl;
provider=System.Data.SqlClient;
provider connection string="
Data Source=myservername;
Initial Catalog=databasename;
Integrated Security=True;
MultipleActiveResultSets=True;
App=EntityFramework""
providerName="System.Data.EntityClient" />
this is my server connection string
<add name="myconnectionstring"
connectionString="metadata=res://*/App_Code.db.csdl|res://*/App_Code.db.ssdl|res://*/App_Code.db.msl;
provider=System.Data.SqlClient;
provider connection string="
Data Source=myservername\SQLEXPRESS;
Initial Catalog=databasename;
Integrated Security=True;
MultipleActiveResultSets=True;
App=EntityFramework""
providerName="System.Data.EntityClient" />
No comments:
Post a Comment