locked
Entity Framework 4.1 The provider did not return a ProviderManifestToken string Exception RRS feed

  • Question

  • I downloaded the Asp.NET MVC 3 EntityFramework Code first sample application in vb.net and modified the connection string as I don't have SQL Server Express Edition to try it with Sql Server 2008 Web Edition

     

    <add name="ApplicationServices"
             connectionString
    ="Server=MyPC\Sql2008;Trusted_Connection=True;MultipleActiveResultSets=True"
             providerName
    ="System.Data.SqlClient" />

    when I try to run the application then ProviderIncompatibleException exception is thrown. And following error is displayed in the browser window.

    Server Error in '/' Application.

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)

    Source Error:

    Line 24: Line 25: Line 26: @For Each item In Model Line 27: @ Line 28:

    Source File: C:\Documents and Settings\Shishir Shukla\My Documents\Downloads\CodeFirstEFVB\CodeFirstMVC\Views\Blog\Index.vbhtml Line: 26

    The connection string which I have used works perfectly with my asp.net webforms application and also Winforms application.

    Please help me soon to get rid of this problem as I have just switched to MVC.

    Thursday, September 8, 2011 11:56 AM

Answers