none
Asp.net mvc connection string RRS feed

  • Question

  • The existing application have the connection string like this

    <connectionStrings>
        <add name="MusicStoreEntities"
         connectionString="Data Source=|DataDirectory|MvcMusicStore.sdf"
         providerName="System.Data.SqlServerCe.4.0"/>
      </connectionStrings>

    I want to connect directly to the database with following connection string.

    <connectionStrings>
        <add name="MusicStoreEntities"
         connectionString="Data Source=(local);Initial Catalog=MvcMusicStore;user=sa;Password=office"
         providerName="System.Data.SqlServerCe.4.0"/>
      </connectionStrings> 

    but it gives following exception.

    Unable to find the requested .Net Framework Data Provider.  It may not be installed.

    Could you please help me.

    • Moved by lucy-liuModerator Wednesday, May 30, 2012 5:49 AM it is a ado.net issue (From:Visual Studio Editor)
    Tuesday, May 29, 2012 6:32 AM

Answers

All replies

  • Hi bikashch14,

    Thank you for your post.

    Based on this case relate to ADO.Net, i am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

    Thank you for your understanding and support.

    Best regards,

    Ego

      
    Wednesday, May 30, 2012 6:19 AM
  • You need to download and install SQL Server Compact 4.0. Verify if this is installed and if not then install it and try again and tell us whether or not that solved the problem.
    Wednesday, May 30, 2012 8:21 AM