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

Post a Comment

Popular posts from this blog

java - How to pass parameters between Request-Scoped Controllers? -

java - How to pass parameters between Request-Scoped Controllers? - i have simple jsf-page , want pass parameter page1 page2. every page has own controller in request scope. the 2 controllers this: controller1: @component("requestcontroller1") @scope("request") public class requestcontroller1 { private list<product> products; private product selectedproduct; @postconstruct public void init() { //load products db } public void setproducts(list<product> products) { this.products = products; } public list<product> getproducts() { homecoming products; } public void setselectedproduct(product selectedproduct) { this.selectedproduct = selectedproduct; } public product getselectedproduct() { homecoming selectedproduct; } controller2: @component("requestcontroller2") @scope("request") public class requestcontroller2 { private long selectedproductid; @postconstruct public void init() ...
Read more

actionscript 3 - Flex: moving a point with rotation doesnt change the point XY? -

actionscript 3 - Flex: moving a point with rotation doesnt change the point XY? - i have follow issue : i have point setted @ border on component, changed transform point center of component in order match component rotation. the of import part when seek point xy after rotation - remains same before rotation. how xy, after rotation ( changeing point.rotation property specific degrees of rotaion ) if want point after rotation, cos(r) * x, sin(r) * y easiest way. if want point after transformations, should able utilize displayobject.transform.transformpoint(x, y) . there's displayobject.localtoglobal . in case phone call localtoglobal(x, y) , localtoglobal(0, 0) , calculate difference. see transform livedocs , displayobject livedocs flex actionscript-3
Read more

ms access - C# - Using OleDbParameter on table name -

ms access - C# - Using OleDbParameter on table name - i want protect app sql injection. want utilize oledbparameter in sql query table name ({1}). the problem doesn't work (error in or that). can pass oledbparameter in {3} thought. example: idbcommand cmd = m_oconnection.createcommand(); cmd.commandtype = commandtype.text; cmd.commandtext = string.format("select {0} {1} {2}={3}", "parentid", "?", swhere, "?" ); cmd.parameters.add(new oledbparameter("@stable", stable)); cmd.parameters.add(new oledbparameter("@id", id)); what can do? forced write function escapes sql characters hand? if yes, can find perfect function? thanks so know can't parameterize table names this cmd.commandtext = string.format("select {0} [{1}] {2}={3}", "parentid", stable, swhere, ...
Read more