I'm trying to install a newsletter studio package on my webmatrix/umbraco site
but im getting this error:
Could not load control: '/umbraco/newsletterstudio/usercontrols/dashboard.ascx'. Error message: System.Data.EntityException: The underlying provider failed on ConnectionString. ---> System.ArgumentException: Keyword not supported: 'datalayer'. at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) at System.Data.EntityClient.EntityConnection..ctor(String connectionString) at System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) at NewsletterStudio.Helper.GetNewNewsletterContainer() at ASP.umbraco_newsletterstudio_usercontrols_dashboard_ascx..ctor() at __ASP.FastObjectFactory_app_web_dashboard_ascx_2b1ca25b_g6mcnwru.Create_ASP_umbraco_newsletterstudio_usercontrols_dashboard_ascx() at System.Web.Compilation.BuildResultCompiledType.CreateInstance() at System.Web.UI.TemplateControl.LoadControl(IWebObjectFactory objectFactory, VirtualPath virtualPath, Type t, Object[] parameters) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at umbraco.cms.presentation.dashboard.OnInit(EventArgs e)
Could it be becuase I'm running a local environment?
Getting an error
Hey,
I'm trying to install a newsletter studio package on my webmatrix/umbraco site
but im getting this error:
Could not load control: '/umbraco/newsletterstudio/usercontrols/dashboard.ascx'.
Error message: System.Data.EntityException: The underlying provider failed on ConnectionString. ---> System.ArgumentException: Keyword not supported: 'datalayer'. at System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) at System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) at System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) at System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) --- End of inner exception stack trace --- at System.Data.EntityClient.EntityConnection.ChangeConnectionString(String newConnectionString) at System.Data.EntityClient.EntityConnection..ctor(String connectionString) at System.Data.Objects.ObjectContext.CreateEntityConnection(String connectionString) at NewsletterStudio.Helper.GetNewNewsletterContainer() at ASP.umbraco_newsletterstudio_usercontrols_dashboard_ascx..ctor() at __ASP.FastObjectFactory_app_web_dashboard_ascx_2b1ca25b_g6mcnwru.Create_ASP_umbraco_newsletterstudio_usercontrols_dashboard_ascx() at System.Web.Compilation.BuildResultCompiledType.CreateInstance() at System.Web.UI.TemplateControl.LoadControl(IWebObjectFactory objectFactory, VirtualPath virtualPath, Type t, Object[] parameters) at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath) at umbraco.cms.presentation.dashboard.OnInit(EventArgs e)
Could it be becuase I'm running a local environment?
Hi Mathias!
Thanks for trying the package! I have never seen this error before but it seems to to be something wrong with the security settings.
http://th2tran.blogspot.com/2009/06/underlying-provider-failed-on-open.html
http://forums.asp.net/t/1421189.aspx/1
The package uses entity framework as "data layer" and only support MS SQL Server. There may be updates in the future to support other databases.
Supporting other databases (MySQL - hint hint!) would be very useful :-)
Hi again mathias!
Could you share your set up with me? Webmatix? Which db are you using? Os?
Gordon: That's something that we are planing for but dicided to go with SQL Server for simplicity and to se the reaction from the community.
Hi Markus,
Yeah.. well I'm using webmatrix - but with umbraco's own db.. so it's kinda my fault - I'll try with an MSSQL server.
Hi!
Just what to let you know that we now supports mysql as db. Follow instructions and download here: http://our.umbraco.org/projects/backoffice-extensions/newsletter-studio
is working on a reply...