The specified store provider cannot be found in the configuration, or is not valid.


  • I am using Visual Studio 2010 SP1 (Beta) and SQL CE 4.0. This works locally on my machine but when I publish I get the error in the title. I have copied the SQL CE 4 assemblies over to my bin folder but that did not help.

    My web.config looks like this:

    <?xml version="1.0"?>
      <compilation debug="true" targetFramework="4.0">
        <add assembly="System.Data.Entity, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
      <add name="ContentDBEntities" connectionString="metadata=res://*/DataModel.DataModel.csdl|res://*/DataModel.DataModel.ssdl|res://*/DataModel.DataModel.msl;provider=System.Data.SqlServerCe.4.0;provider connection string=&quot;Data Source=|DataDirectory|\ContentDB.sdf&quot;" providerName="System.Data.EntityClient" />

    Any help would be greatly appreciated.

     “Somewhere someone is practicing, if you're not and you should meet, you will lose…”

    • Edited by 01000011 Monday, January 17, 2011 6:54 PM format
    Monday, January 17, 2011 6:50 PM


All replies