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.
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.
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:
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34212
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
Did you guys resolve this problem?
Thanks
Ryan
is working on a reply...