an ASP.NET Open Source CMS & eCommerce platform
Search:
Skip Navigation LinksHome > DotShoppingCart Forums > Development > DotShoppingCart OpenSource Core > The stored procedure 'DSC_Template_GetTimeS...
The stored procedure 'DSC_Template_GetTimeStampByName' doesn't exist.
Last Post 3/25/2013 8:05:51 AM By timofeia. 1 replies.
3/24/2013 2:43:30 PM
timofeia
Posts: 31
Joined: 3/21/2013
The stored procedure 'DSC_Template_GetTimeStampByName' doesn't exist.
After installation when I run app from web browser or from VS 2010 i'm getting the same errorr:

The stored procedure 'DSC_Template_GetTimeStampByName' doesn't exist.

Exception Details: System.InvalidOperationException: The stored procedure 'DSC_Template_GetTimeStampByName' doesn't exist.
Line 103:            NamedTimeStamp timeStamp = null;
Line 104:            Database db = DBController.CreateDatabase(host);
Line 105:            DbCommand cmd = db.GetStoredProcCommand(TimeStampProc, key);
Line 106:            dep = enableSqlDep ? DBController.GetSqlCacheDependency(host, (SqlCommand)cmd) : null;
Line 107:            using (IDataReader dataReader = db.ExecuteReader(cmd)) {
I checked the database - dotshoppingcart, there is no stored procedures at all (except System Stored Procedures). What is the reason for this error message? thank you.
 
3/25/2013 8:05:51 AM
timofeia
Posts: 31
Joined: 3/21/2013
Re: The stored procedure 'DSC_Template_GetTimeStampByName' doesn't exist.
After reinstalling SQL Server 2008 R2 (first uninstalling everything related to SQL Server 2008 through Control Panel) database installation was successful. The last two parameters (mail.yourserver.com system@yourdomain.com) were not accepted as optional on my computer. Now database is OK.
Project hosted at CodePlex.com
Copyright © 2013 DotShoppingCart. All rights reserved.