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
 
 
Thread Tools Display Modes
  #1 (permalink)  
Old October 30th, 2006, 09:54 PM
Registered User
 
Join Date: Oct 2006
Location: , , China.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can't find a Procedure?

When I was running thePhile project , i got a Error message like this:

The error occurred in: http://localhost/thephile/Default.aspx
Error Message: δҵ洢 'sp_Polls_GetCurrentQuestionID'

Translate to English is : Can't Find Procedure 'sp_Polls_GetCurrentQuestionID';

I hv checked my sqlserver2000 ,there hv that procedure!!
I was building the project referring the document in download zip file.And i restored the database as the document ask;

what can i do now?

Any suggestion will be appreciated!

ChengWei
  #2 (permalink)  
Old October 30th, 2006, 10:53 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You need to load your DB from the backup file in the code download, and not from the sql script. The backup file was updated after the book was published, but not the sql script.

  #3 (permalink)  
Old October 31st, 2006, 01:05 AM
Registered User
 
Join Date: Oct 2006
Location: , , China.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here are the document asks me to do:
Restore the thephile-database-backup database file in SQL Server Enterprise Manager
Copy the file thephile-database-backup.bak into your SQL Server backup folder
Create a new database called thePhile
Right click the new database, click All Tasks then Restore Database
Select From Device
Click Select Devices
Click Add
Use the filename box to select the thephile-database-backup.bak file.
Click OK
Click OK again
Click OK once more

Then server give me a message said that restore DB successfully.

It's there any wrong in my process?

  #4 (permalink)  
Old October 31st, 2006, 01:59 AM
Registered User
 
Join Date: Oct 2006
Location: , , China.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

It's ok Now!
I hv got another copy from my friend ,i just do the same steps as usual.
And it's working correctly....
i don't know why....
and i just download the code again from wrox.com,but it also don't work.....

  #5 (permalink)  
Old October 31st, 2006, 04:08 AM
Registered User
 
Join Date: Sep 2006
Location: Pinetown, none, South Africa.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to sibusiso Send a message via Yahoo to sibusiso
Default

Hi I had the same error as well, you have to check the all the connection strings in the config folder that the database name is specified like <ConnectionString>server=CHARUL\NetSDK;database=Th ePhile;uid=sa;pwd=;</ConnectionString>

Bulldog.NET (South Africa)
  #6 (permalink)  
Old October 31st, 2006, 10:03 AM
Registered User
 
Join Date: Oct 2006
Location: , , China.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

i hv searched in the project for ConnectionString ,and i changed to
<ConnectionString>server=localhost;database=ThePhi le;uid=sa;pwd=sa;</ConnectionString>(my pwd is sa)

there are six places,files all in the Config dir!
and also changed the web.config
<sessionState
            mode="InProc"
            stateConnectionString="tcpip=127.0.0.1:42424"
            sqlConnectionString="data source=localhost;user id=sa;password=sa"
            cookieless="false"
            timeout="20"
    />

but it does't work....
it has confused me alot!
  #7 (permalink)  
Old October 31st, 2006, 04:02 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

The session state setting in web.config isn't being used because we're not storing our session state there. Only the config files in the config folder matter.

Your problem is likely the servername. "localhost" is a common TCP/IP alias for your computer, but it's not a valid SQL Server name. SQL Server wants either:

Server=(local)
   or
Server=.
   or
Server=ACTUALCOMPUTERNAME

However, if you are using a named instance you'll have to specify the name, as sibusiso did. His computername is CHARUL and he's using the named instance of MSDE (free version of SQL 2K) that was installed with the .NET SDK, so that's where he got his name from. Only one SQL Server installation on a given computer can have no name. If you have more than one, then they require names.

I made another post here a few minutes ago that has a console program you can run to test your connection string. Please try that.

Eric

  #8 (permalink)  
Old October 31st, 2006, 08:34 PM
Registered User
 
Join Date: Oct 2006
Location: , , China.
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I got it.
i hv just changed my web.config file ,it really works.
Thanks a lot !!!
Now I am reading the chapt 2,i think when i going on, there will be many other questions to ask.
Thanks again to Eric and sibusiso....

  #9 (permalink)  
Old October 31st, 2006, 09:31 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Atlanta, Georgia, USA.
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
Default

You can save yourself some trouble by getting my update to this project. Look at the last post here:

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

Eric

 


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
Could Not find stored Procedure kavyach BOOK: ASP.NET Website Programming Problem-Design-Solution 1 June 10th, 2005 06:53 AM
Open Word Doc from Access - find, find next save donaldmaloney Access VBA 1 May 25th, 2005 11:09 AM
Could not find stored procedure ianmc BOOK: ASP.NET Website Programming Problem-Design-Solution 16 August 20th, 2004 03:40 PM
Create a find and a find and replace in VB.NET snowy0 VB How-To 0 January 26th, 2004 06:03 PM
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 05:03 PM.


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