Please ensure that your data service is online and running and that the connection string in your web.config file is correct and make sure the key specified by
ConnnectionStringName exists in connectionStrings section.
To configure your connection string:
1. Open [Install Location of eCommerce Framework]\PublicStore\web.config
2. Within web.config find the configuration section (highlighted) below:
|
<configuration>
<ClientConfig>
<Settings ConnectionStringName="EcfSqlConnection" SubscriptionId="{SUBSCRIPTION_GUID}"
CartKey="ShoppingCartKey" AffiliateKey="AffiliateKey" Expires="24"></Settings>
</ClientConfig>
...
<connectionStrings>
<add name="EcfSqlConnection" connectionString="{connection string to your database}"/>
</connectionStrings>
</configuration>
|
System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode)
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
at Mediachase.eCF.DataLayer.Provider.SqlDataProvider.LoadTable(DataCommand command) in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\SupportProjects\Data\SqlDataProvider\SqlDataProvider.cs:line 251
at Mediachase.eCF.DataLayer.Provider.DataService.LoadTable(DataCommand command) in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\SupportProjects\Data\DataProvider\DataService.cs:line 52
at Mediachase.eCF.DataLayer._GlobalSetting.LoadAll() in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\BusinessLayer\BusinessLibrary\Data\Generated\_GlobalSetting.cs:line 45
at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.LoadHash() in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\BusinessLayer\BusinessLibrary\Common\Configuration\SettingsManager.cs:line 71
at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.GetParamValue(String ParamName) in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\BusinessLayer\BusinessLibrary\Common\Configuration\SettingsManager.cs:line 120
at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.GetBooleanValue(String ParamName, Boolean DefaultValue) in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\BusinessLayer\BusinessLibrary\Common\Configuration\SettingsManager.cs:line 143
at Mediachase.eCF.BusLayer.Common.Configuration.SettingsManager.GetBooleanValue(String ParamName) in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\BusinessLayer\BusinessLibrary\Common\Configuration\SettingsManager.cs:line 158
at Mediachase.eCF.BusLayer.FrameworkContext.get_StoreClosed() in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\BusinessLayer\BusinessLibrary\FrameworkContext.cs:line 242
at Mediachase.eCF.BusFacade.Engine.ServicePipeHelper.CheckSubscription(String SubscriptionId, IList`1& errorArray) in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\BusinessLayer\FacadeLibrary\Engine\ServicePipeHelper.cs:line 470
at Mediachase.eCF.BusFacade.SiteNodeManager.SiteNodeLookup(SiteNodeLookup lookup) in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\BusinessLayer\FacadeLibrary\SiteNodeManager.cs:line 119
at Mediachase.eCF.ClientLib2.ClientCatalog.LookupPages(String[] pages, String[] responseGroups, ErrorsError[]& errors) in C:\Documents and Settings\mlosapio\My Documents\~Projects\Dreamland\eCommerce Framework SDK 4.1\PublicLayer\ClientLibrary\ClientCatalog.cs:line 280
|