i am not getting creating or using existing database in MVC 3

Question

0.00/5 (No votes)

See more:

hi to all.

i m not getting the database connetion in mvc 3 using razor
i have created one small application that connects the model to database.
i have set up the connection string of server this works well
but as i changes the connection string to my local server it shows following error.

The provider did not return a ProviderManifestToken string

here i have connection strings first one is of server that creates database on server.

C#

< add name="MoviesContext" connectionstring="Data Source=SERVER\SQL2008;Initial Catalog=Movies;User Id=sa;Password=Admin@101;" providerName="System.Data.SqlClient" >;


< add name="MoviesContext" connectionstring="Data Source=KAUSHAL-PC\SQL2008;Initial Catalog=Movies;">
        providerName="System.Data.SqlClient" >;

thanks in advance..

Posted 31-Aug-12 5:25am

Ritesh Rana

Updated 31-Aug-12 8:13am

luisnike19

v3

Add a Solution

Comments

[no name] 31-Aug-12 11:37am

Try reading through http://stackoverflow.com/questions/5423278/ef-4-1-exception-the-provider-did-not-return-a-providermanifesttoken-string and see if that helps

Ritesh Rana 31-Aug-12 12:40pm

I have reviewed that but not working for me..

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)

**Zoltán Zörgő** · Accepted Answer · 2012-08-31T08:18:00

The connection string you have posted are for plain ado.net. But I suppose you have EntityFramework. EF's connection string is a little bit more complicated.
Read here about how to build it: http://msdn.microsoft.com/en-us/library/bb738533.aspx[^]
And how to write it: http://msdn.microsoft.com/en-us/library/cc716756.aspx[^]