Copied to clipboard

Flag this post as spam?

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


  • Ganesh Mitra 1 post 21 karma points
    Mar 14, 2015 @ 14:33
    Ganesh Mitra
    0

    Database migration error on shared server for umbraco website

    I uploaded the umbraco 7 website on a shared server. Its working fine with .sdf file but while I am trying to set new connection string  to database in web.config (migrated the database from sdf file using webmatrix) , showing error.

     

     

     

    Server Error in '/' Application.

    Error running Reader: 
    SQL Statement:
    SELECT id, domainName FROM umbracoDomains ORDER BY id

    Exception:
    System.ArgumentException: Keyword not supported: 'server'.
      at System.Data.SqlServerCe.SqlCeConnectionStringBuilder.set_Item(String keyword, Object value)
      at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
      at System.Data.SqlServerCe.SqlCeConnectionStringBuilder..ctor(String connectionString)
      at System.Data.SqlServerCe.SqlCeConnection.set_ConnectionString(String value)
      at SQLCE4Umbraco.SqlCeContextGuardian.EnsureOpenBackgroundConnection(String connectionString)
      at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
      at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

    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: SqlCE4Umbraco.SqlCeProviderException: Error running Reader: 
    SQL Statement:
    SELECT id, domainName FROM umbracoDomains ORDER BY id

    Exception:
    System.ArgumentException: Keyword not supported: 'server'.
      at System.Data.SqlServerCe.SqlCeConnectionStringBuilder.set_Item(String keyword, Object value)
      at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
      at System.Data.SqlServerCe.SqlCeConnectionStringBuilder..ctor(String connectionString)
      at System.Data.SqlServerCe.SqlCeConnection.set_ConnectionString(String value)
      at SQLCE4Umbraco.SqlCeContextGuardian.EnsureOpenBackgroundConnection(String connectionString)
      at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
      at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

    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: 

    [SqlCeProviderException: Error running Reader: 
    SQL Statement:
    SELECT id, domainName FROM umbracoDomains ORDER BY id
    
    Exception:
    System.ArgumentException: Keyword not supported: 'server'.
       at System.Data.SqlServerCe.SqlCeConnectionStringBuilder.set_Item(String keyword, Object value)
       at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
       at System.Data.SqlServerCe.SqlCeConnectionStringBuilder..ctor(String connectionString)
       at System.Data.SqlServerCe.SqlCeConnection.set_ConnectionString(String value)
       at SQLCE4Umbraco.SqlCeContextGuardian.EnsureOpenBackgroundConnection(String connectionString)
       at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
       at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)]
       SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +409
       SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) +26
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +161
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +361
       umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0() +148
       Umbraco.Core.Cache.<>c__DisplayClass1`1.<GetCacheItem>b__0() +15
       System.Lazy`1.CreateValue() +497
       System.Lazy`1.get_Value() +14338318
       Umbraco.Core.Cache.HttpRuntimeCacheProvider.GetCacheItem(String cacheKey, Func`1 getCacheItem, Nullable`1 timeout, Boolean isSliding, CacheItemPriority priority, CacheItemRemovedCallback removedCallback, CacheDependency dependency) +798
       Umbraco.Core.Cache.HttpRuntimeCacheProvider.GetCacheItem(String cacheKey, Func`1 getCacheItem, Nullable`1 timeout, Boolean isSliding, CacheItemPriority priority, CacheItemRemovedCallback removedCallback, String[] dependentFiles) +200
       Umbraco.Core.Cache.CacheProviderExtensions.GetCacheItem(IRuntimeCacheProvider provider, String cacheKey, Func`1 getCacheItem, Nullable`1 timeout, Boolean isSliding, CacheItemPriority priority, CacheItemRemovedCallback removedCallback, String[] dependentFiles) +264
       umbraco.cms.businesslogic.web.Domain.GetDomains(Boolean includeWildcards) +421
       Umbraco.Web.Routing.PublishedContentRequestEngine.FindDomain() +257
       Umbraco.Web.Routing.PublishedContentRequestEngine.PrepareRequest() +18
       Umbraco.Web.UmbracoModule.ProcessRequest(HttpContextBase httpContext) +503
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +165
    



    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34212

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Mar 14, 2015 @ 14:38
    Jan Skovgaard
    0

    Hi Ganesh and welcome to our :)

    Are you certain that connection string is correct? It would help if you could post the exact error message you're seeing in here please.

    Remember to set <customErrors mode="off"> in the web.config file if you have not done so already. Otherwise you'll just see a message telling you to do this.

    /Jan

  • Ryan Nguyen 27 posts 80 karma points
    Apr 17, 2015 @ 21:48
    Ryan Nguyen
    0

    Did you guys resolve this problem?

    Thanks

    Ryan

Please Sign in or register to post replies

Write your reply to:

Draft