Copied to clipboard

Flag this post as spam?

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


  • David Dillman 2 posts 22 karma points
    Dec 02, 2010 @ 19:40
    David Dillman
    0

    Keyword not supported: 'datalayer'

    umbraco v 4.5.2 (Assembly version: 1.0.3891.20719)

    Koiak_Standard_Site_1.1

    ASP.NET 4

    Windows 2008, IIS Version 7

    We are currently evaluating Umbraco to see if we would like to use it in our website redesign project.  The system is brand new without any packages installed in it  When I try to install Koiak_Standard_Site_1.1 I am getting the following error.

    Any help would be greatly appreciated.

    With Regards

    David C Dillman

     

     

    Keyword not supported: 'datalayer'.
    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.ArgumentException: Keyword not supported: 'datalayer'.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
     

    Stack Trace:

    [ArgumentException: Keyword not supported: 'datalayer'.]
       System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +6337982
       System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +134
       System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +103
       System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +35
       System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +253
       System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +60
       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +68
       Koiak.BasicSite.usercontrols.BasicSiteInstall.Page_Load(Object sender, EventArgs e) +5148
       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
       System.Web.UI.Control.LoadRecursive() +71
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3048

  • Jesper Ordrup 1019 posts 1528 karma points MVP
    Dec 02, 2010 @ 20:02
    Jesper Ordrup
    1

    In web.config, find the appsetting for db called "umbracoDbDSN". If there's anything "datalayer" there - just remove it .. Here's an example of a correct one for MS SQL:

      <add key="umbracoDbDSN" value="server=.\SQLEXPRESS;database=umbraco45demo;user id=umbraco;password=nomatterwhatyoudoyourenotgonnaguessit" />

    Good luck
    Jesper

  • David Dillman 2 posts 22 karma points
    Dec 03, 2010 @ 19:24
    David Dillman
    0

    After we removed the datalayer parameter and restarted the server we were no longer able to logon to umbraco.  It would not accept any of the IDs / Passwords.

    Thanks

    David

     

    Our Original Line:

    <add key="umbracoDbDSN" value="server=servername;database=databasename;user id=username;password=password;datalayer=MySql" />

    Updated Line:

    <add key="umbracoDbDSN" value="server=servername;database=databasename;user id=username;password=password" />

  • Tommy Poulsen 514 posts 708 karma points
    Dec 03, 2010 @ 19:30
    Tommy Poulsen
    2

    It sounds as one of the packages you rely on does not support MySql - if you feed a MySql connection string to a SQLServer adapter it will raise an error similar to this, as far as I remember

    >Tommy

  • Paul D 1 post 21 karma points
    Jan 18, 2011 @ 06:12
    Paul D
    0

    Hello,

    Is there any update to this issue, as I am getting the same error?

    Also, does this package require MySql?  I am using MS SQL.

    Lastly, how does one create an "empty" Umbraco site to then import this package?  I am working in Microsoft WebMatrix.

    Thanks,
    Paul

  • Petr Snobelt 923 posts 1535 karma points
    Jan 18, 2011 @ 08:53
    Petr Snobelt
    0

    It looks like (from stack trace) that Koiak.BasicSite don't support datalayer, try verify it

     

    Petr

  • Raheel 62 posts 81 karma points
    Jan 25, 2011 @ 01:17
    Raheel
    0

    I am stuck on this as well :(

  • Chris Koiak 700 posts 2626 karma points
    Jan 25, 2011 @ 14:34
    Chris Koiak
    0

    This package runs some SQL during the install process using the Enterprise Data blocks. Looks like this doesn't support the 'datalayer' syntax.

    It looks like this package is restricted to MS SQL databases only.

  • Matt Brailsford 4125 posts 22223 karma points MVP 9x c-trib
    Jan 25, 2011 @ 14:54
    Matt Brailsford
    2

    It does indeed sound like the package MS SQL Server specific.

    I had a similar issue with one of my packages not supporting SQL CE 4 in 4.6. The easy fix is to use the built in Application.SqlHelper within Umbraco to do your database calls. Umbraco constructs a SQL Connection for you based upon the Umbraco config, then you can just use the methods of the SQL helper to execute your scripts.

    Hope this helps.

    Matt

  • Chris Koiak 700 posts 2626 karma points
    Jan 26, 2011 @ 20:27
    Chris Koiak
    0

    Thanks Matt, but that's exactly what I do.

    SqlHelper.ExecuteScalar(GlobalSettings.DbDSN, CommandType.Text, "UPDATE cmsDataTypePreValues SET [value] = 'CheckBoxList|" + slideShowId + "||False' where [value] = 'CheckBoxList|1128||False'");

    I do use the Membership API a lot, and a obsolete method called "AddGroup". I'll using the new method AddUserToRole and see if this works.

Please Sign in or register to post replies

Write your reply to:

Draft