asp.net - Keyword not supported: 'server' -



asp.net - Keyword not supported: 'server' -

i've been trying edit connection string uploading website server. not experienced this. got exception: keyword not supported: 'server'. here connection string:

<add name="albayanentities" connectionstring="server=xx.xx.xxx.xxx,xxxx;database=albayan;uid=bayan;password=xxxxx;" providername="system.data.entityclient" />

i've tried embed string old connection string works locally, didn't fit : s

for entity framework (database-first or model-first; when have physical edmx model file) need utilize special type of connection string quite different straight ado.net connection strings else has mentioned far...

the connection string must like:

<add name="testentities" connectionstring="metadata=res://*/model1.csdl|res://*/model1.ssdl|res://*/model1.msl;provider=system.data.sqlclient;provider connection string=&quot;data source=(local);initial catalog=test;integrated security=true;multipleactiveresultsets=true;app=entityframework&quot;" providername="system.data.entityclient" />

inside connection string, you'll find provider connection string= attribute ado.net connection string:

provider connection string=&quot;data source=(local);initial catalog=test;integrated security=true;multipleactiveresultsets=true;app=entityframework&quot;"

so here, need alter server name , perchance other settings.

data source=.... stands server (you can utilize server=.....) initial catalog=..... stands database (you can utilize database=....)

asp.net sql-server-2008 entity-framework ado.net connection-string

Comments

Popular posts from this blog

iphone - Dismissing a UIAlertView -

c# - Can ProtoBuf-Net deserialize to a flat class? -

javascript - Change element in each JQuery tab to dynamically generated colors -