Copied to clipboard

Flag this post as spam?

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


  • suzyb 474 posts 932 karma points
    Aug 03, 2012 @ 11:46
    suzyb
    0

    SQL server error 'datetime2' not supported

    Does version 1.3 require a certain version of SQL server to work.  After installing I get this error

    This version of SQL Server in use does not support datatype 'datetime2' error

    We are running on SQL Server 2005.

  • Markus Johansson 1924 posts 5831 karma points MVP 2x c-trib
    Aug 03, 2012 @ 16:41
    Markus Johansson
    0

    Hi!

    Sorry, our misstake the the compiled manifest for sql server was 2008, we have changed it and uploaded a new file to the deli-page.

    Please try to download it again:

    http://our.umbraco.org/projects/backoffice-extensions/newsletter-studio/

    // M

    Edit: datetime2 is new to SQL Server 2008, it's not needed so chaning the "ProviderManifest" in the edmx-file solves the problem. Every time you reconnect to the database and updated the entity framework schema the provider manifest is changed to the current version of SQL Server. That's why we forgot to change it back.

  • suzyb 474 posts 932 karma points
    Aug 03, 2012 @ 17:04
    suzyb
    0

    I marked this solved a little prematurely :/  After installing, the section icon isn't being added.

  • suzyb 474 posts 932 karma points
    Aug 07, 2012 @ 10:46
    suzyb
    0

    Found out what the problem was.  The database tables hadn't been deleted when I'd uninstalled so the reinstallation wasn't completing properly.

Please Sign in or register to post replies

Write your reply to:

Draft