How do I set connection string

Question

0.00/5 (No votes)

See more:

Hello All,
I have created a website and have used entity framework with database,when I run in localhost it works fine but when I host the website on server and browse my website i get this error:

Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.

and my connectionstring is this:

HTML

<connectionStrings>
    <add name="DBEntities" 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=local;initial catalog=DB;persist security info=True;user id=user1;password=pass1;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
  </connectionStrings>
  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
  </entityFramework>

what is wrong?how do solve this?
please help me.
Thanks in Advance.

Posted 19-Apr-14 1:07am

NewWebDesigner

Updated 19-Apr-14 5:23am

karthik Udhayakumar

v2

Add a Solution

Comments

NewWebDesigner 19-Apr-14 8:19am

i recieve an email by this word:
prasanna.raj has posted an answer to your question about "How do I set connection string"
but i cannot see this answer online in your site!
why?

[no name] 19-Apr-14 8:25am

Maybe because he deleted it? Or it was deleted for him?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

karthik Udhayakumar · Answer 1 · 2014-04-19T05:29:00

Solution 3

Hello WebDesigner,

Check your server's error logs.
The error message you have shared is vague and generic.

So some steps I can suggest you to have:"

1:Try restarting the server or VM.
2.Try restarting the Application pool in the IIS.
3.Try deleting and creating the Application pool once again.

(FYI)This error doesnt have any connection with the connection string:)

Posted 19-Apr-14 5:29am

karthik Udhayakumar

Comments

NewWebDesigner 20-Apr-14 1:26am

thanks for your answer.first time i restore database from backup,but this time create from generate script and my problem solved.