Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Tim Davis 4 posts 84 karma points
    Apr 21, 2019 @ 14:06
    Tim Davis
    0

    SQL CE 4.0 - Can't find 4.0.8902.1

    So decided to try and use Umbraco from Nuget package, I'm being told that can't find find SQL CE Native components that match version 8902. So I ensure I've got the latest SP 1 for SQL CE 4.0 and that version number is lower.

    So I download the Umbraco 8 zip to compare version numbers on the Native components....the zip file contains (for example) sqlceca40.dll with a File Version of 4.0.8902.1.

    Where are the Umbraco devs getting this hidden SQL CE 4.0 SP that nobody else seems to know about, including Microsoft?

  • Sebastiaan Janssen 5060 posts 15522 karma points MVP admin hq
    Apr 22, 2019 @ 07:06
    Sebastiaan Janssen
    100

    We turned it into a NuGet package here: https://www.nuget.org/packages/Umbraco.SqlServerCE/4.0.0.1

    And the original source is listed in this blog post: https://erikej.blogspot.com/2016/02/sql-server-compact-40-sp1-hotfix.html

    Note that you shouldn't have to install the components on your PC as long as the correct dlls are in place in your bin folder and the SQL CE assembly binding is in your web.config:

            <dependentAssembly>
                <assemblyIdentity name="System.Data.SqlServerCe" publicKeyToken="89845DCD8080CC91" culture="neutral" />
                <bindingRedirect oldVersion="0.0.0.0-4.0.0.1" newVersion="4.0.0.1" />
            </dependentAssembly>
    
  • Tim Davis 4 posts 84 karma points
    May 01, 2019 @ 11:52
    Tim Davis
    0

    Sabastiaan,

    That makes sense thank you! Only way I can get Umbraco to function is to remove all other SQL CE installs from my machine, so I got it working.

    Thanks!

  • Paul Johnson 18 posts 109 karma points
    Oct 15, 2021 @ 18:28
    Paul Johnson
    0

    Sorry to resurrect old thread, but this is indexed pretty well.

    Workaround and some details here https://github.com/umbraco/Umbraco-CMS/issues/11384

Please Sign in or register to post replies

Write your reply to:

Draft