Wrox Programmer Forums
|
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
Welcome to the p2p.wrox.com Forums.

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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 20th, 2004, 07:34 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hey,

Who is the owner of the proc?

Brian
 
Old August 20th, 2004, 08:00 AM
Authorized User
 
Join Date: Nov 2003
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to seanmayhew
Default

I restored from the correct database and the sp is owned by dbo and is still not working.
 
Old August 20th, 2004, 08:04 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hey,

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)?

Brian
 
Old August 20th, 2004, 08:07 AM
Authorized User
 
Join Date: Nov 2003
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to seanmayhew
Default

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
 
Old August 20th, 2004, 08:51 AM
Authorized User
 
Join Date: Nov 2003
Posts: 37
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to seanmayhew
Default

Here is my complete error:

Code:
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()
 
Old August 20th, 2004, 09:03 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hey,

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.

Brian
 
Old August 20th, 2004, 03:40 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

http://p2p.wrox.com/topic.asp?TOPIC_ID=14583

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.

Eric





Similar Threads
Thread Thread Starter Forum Replies Last Post
Stored Procedure Help. midway11 SQL Language 3 November 20th, 2006 06:36 AM
Can't find a Procedure? ChengWei BOOK: ASP.NET Website Programming Problem-Design-Solution 8 October 31st, 2006 10:31 PM
Stored Procedure Help BukovanJ SQL Language 2 October 10th, 2006 08:02 AM
Could Not find stored Procedure kavyach BOOK: ASP.NET Website Programming Problem-Design-Solution 1 June 10th, 2005 06:53 AM
Could not find stored procedure 'sp_Polls_GetCurre jblp BOOK: ASP.NET Website Programming Problem-Design-Solution 1 September 18th, 2003 06:10 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.