Could not find stored procedure

bmains · August 20th, 2004, 07:34 AM

Hey,

Who is the owner of the proc?

Brian

seanmayhew · August 20th, 2004, 08:00 AM

I restored from the correct database and the sp is owned by dbo and is still not working.

bmains · August 20th, 2004, 08:04 AM

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

seanmayhew · August 20th, 2004, 08:07 AM

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

seanmayhew · August 20th, 2004, 08:51 AM

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

bmains · August 20th, 2004, 09:03 AM

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

englere · August 20th, 2004, 03:40 PM

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