Click here to Skip to main content
12,951,983 members (64,105 online)
Rate this:
 
Please Sign up or sign in to vote.
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.

< 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
Updated 31-Aug-12 8:13am
v3
Comments
Wes Aday 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

Rate this: bad
 
good
Please Sign up or sign in to vote.

Solution 1

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[^]
  Permalink  

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

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,239
CHill60 3,490
Maciej Los 3,083
Jochen Arndt 1,975
ppolymorphe 1,880


Advertise | Privacy | Mobile
Web01 | 2.8.170525.1 | Last Updated 31 Aug 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100