an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Support > Installation > Another installation problem
Another installation problem
Last Post 10/18/2008 9:33:22 PM By brokensaber. 3 replies.
10/18/2008 7:10:00 AM
brokensaber
Posts: 7
Joined: 10/9/2008
Another installation problem
I'm pretty sure this is error is do to the fact of my ignorance of configuring SQL hehe, any coaching would be appreciated on how to configure it so I can start using DSC.
 
Here is my error
 
<table width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td>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.</td> </tr> </tbody> </table>
Stack Trace:

<table width="100%" bgcolor="#ffffcc"> <tbody> <tr> <td> 
[InvalidOperationException: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.]
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +4861594
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.SqlClient.SqlConnection.Open() +122
   Microsoft.Practices.EnterpriseLibrary.Data.Database.OpenConnection() +138
   Microsoft.Practices.EnterpriseLibrary.Data.Database.DiscoverParameters(DbCommand command) +41
   Microsoft.Practices.EnterpriseLibrary.Data.ParameterCache.SetParameters(DbCommand command, Database database) +62
   Microsoft.Practices.EnterpriseLibrary.Data.Database.GetStoredProcCommand(String storedProcedureName, Object[] parameterValues) +67
   DotShoppingCart.OpenSource.Core.DbFileBase.GetTimeStamp(String host, Object key, SqlCacheDependency& dep) +177
   DotShoppingCart.OpenSource.Core.DbFileBase.GetFile(String host, Object key) +288
   DotShoppingCart.OpenSource.Core.DSCPage.OnPreInit(EventArgs e) +521
   System.Web.UI.Page.PerformPreInit() +31
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +282
</td> </tr> </tbody> </table>
10/18/2008 3:32:17 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: Another installation problem
Did you get homepage loaded at all? If not, then you need to grant the correct DB permission and fix the connectionString in web.config.
DotShoppingCart Staff
10/18/2008 7:31:31 PM
brokensaber
Posts: 7
Joined: 10/9/2008
Re: Another installation problem
No, It didn't load.  As far as the web.config, everything in it is greek to me and I would really like to give DSC a try.
 
When I installed dsc I did get an error at the end while it was batching, though the tables were made is sql.  Are there any recommended configuration settings in SQL I should have enabled?
10/18/2008 9:33:22 PM
brokensaber
Posts: 7
Joined: 10/9/2008
Re: Another installation problem
I reinstalled sql 2005 and installed instdsc.exe with nodemo , then set it up as an app in iis7 under classic and it loaded right up.  I think the problem was my old installation of sql  the sql browser would not enable half the time.
 
Game on now :}
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.