Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
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 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 .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #11 (permalink)  
Old August 20th, 2004, 07:34 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

Hey,

Who is the owner of the proc?

Brian
Reply With Quote
  #12 (permalink)  
Old August 20th, 2004, 08:00 AM
Authorized User
 
Join Date: Nov 2003
Location: , , .
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.
Reply With Quote
  #13 (permalink)  
Old August 20th, 2004, 08:04 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
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
Reply With Quote
  #14 (permalink)  
Old August 20th, 2004, 08:07 AM
Authorized User
 
Join Date: Nov 2003
Location: , , .
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
Reply With Quote
  #15 (permalink)  
Old August 20th, 2004, 08:51 AM
Authorized User
 
Join Date: Nov 2003
Location: , , .
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()
Reply With Quote
  #16 (permalink)  
Old August 20th, 2004, 09:03 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
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
Reply With Quote
  #17 (permalink)  
Old August 20th, 2004, 03:40 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Stored Procedure Help. midway11 SQL Language 3 November 20th, 2006 05:36 AM
Can't find a Procedure? ChengWei BOOK: ASP.NET Website Programming Problem-Design-Solution 8 October 31st, 2006 09: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



All times are GMT -4. The time now is 06:35 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.