I am tired of removing this error.
Project is working fine in Local host problem occurs when i upload it on Go Daddy :
It says :
Server Error in '/' Application.
Could not find stored procedure 'ShowHierarchyForum'.
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: System.Data.SqlClient.SqlException: Could not find stored procedure 'ShowHierarchyForum'.
Source Error:
Line 68: sqlCommand.Parameters.Add(newSqlParam2);
Line 69: sqlCommand.Connection = mycon;
Line 70: SqlDataReader myr = (sqlCommand.ExecuteReader(CommandBehavior.CloseConnection));
Line 71: return myr;
Line 72:
Source File: d:\hosting\9361748\html\App_Code\classes\clsDataAccess.cs Line: 70
Stack Trace:
[SqlException (0x80131904): Could not find stored procedure 'ShowHierarchyForum'.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +1953274
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4849707
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
System.Data.SqlClient.SqlDataReader.get_MetaData() +96
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +954
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +70
JumpyForum.clsDataAccess.getForumData(Int32 ArticleId) in d:\hosting\9361748\html\App_Code\classes\clsDataAccess.cs:70
JumpyForum.Forum.LoadData() in d:\hosting\9361748\html\Forum.aspx.cs:95
JumpyForum.Forum.Page_Load(Object sender, EventArgs e) in d:\hosting\9361748\html\Forum.aspx.cs:74
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
Version Information: Microsoft .NET Framework Version:2.0.50727.4223; ASP.NET Version:2.0.50727.4223