BOOK: ASP.NET Website Programming Problem-Design-Solution
This is the forum to discuss the Wrox book ASP.NET Website Programming: Problem - Design - Solution, Visual Basic .NET Edition by Marco Bellinaso, Kevin Hoffman; ISBN: 9780764543869
You are currently viewing the BOOK: ASP.NET Website Programming Problem-Design-Solution section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
Did you check the connection string to see how it logs into the database? Does it use a SQL Server account instead of the ASPNET account (Integrated Security=True)?
Im using an sa login and I feel confident its working as when I enter the wrong password (on purpose) I get the log in error and not that missing sp error
Page Error
An unexpected error has occurred on this page. The system administrators have been notified. Please feel free to contact us with the information surrounding this error.
The error occurred in: http://localhost/ThePhile/Default.aspx
Error Message: Could not find stored procedure 'sp_Polls_GetCurrentQuestionID'.Stack Trace:
System.Data.SqlClient.SqlException: Could not find stored procedure 'sp_Polls_GetCurrentQuestionID'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Wrox.WebModules.Data.DbObject.RunProcedure(String storedProcName, IDataParameter[] parameters, Int32& rowsAffected) in C:\wrox\ThePhile\Modules\Core\DbObject.cs:line 106 at Wrox.WebModules.Polls.Data.Questions.GetCurrentID() in C:\wrox\ThePhile\Modules\Polls2\Polls.Data\Questions.cs:line 94 at Wrox.WebModules.Polls.Business.Question.GetCurrentID() in C:\wrox\ThePhile\Modules\Polls2\Polls.Business\Question.cs:line 129 at Wrox.WebModules.Polls.Web.Controls.User.Poll.DataBind() in C:\wrox\ThePhile\Modules\Polls2\Poll.ascx.cs:line 123 at Wrox.WebModules.Polls.Web.Controls.User.Poll.Page_Load(Object sender, EventArgs e) in C:\wrox\ThePhile\Modules\Polls2\Poll.ascx.cs:line 114 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain()
That is very odd; try using a different account than sa maybe? Another SQL Server login account with dbo permissions, and specify that in the connection string.
Maybe you're having a problem connecting to the right DB.
Try making the little console mode program I posted in this thread and tell me if it works.
Use the same connction string for this that you are using in your .config files for ThePhile.
This just lists the names of the users in the table Accounts_Users.
If this works, then your connction string is good and your DB looks readable.
This will help us narrow down the problem.
Linear Mode
