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

October 30th, 2006, 10:54 PM
|
Registered User
|
|
Join Date: Oct 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|

October 30th, 2006, 11:53 PM
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.
|

October 31st, 2006, 02:05 AM
|
Registered User
|
|
Join Date: Oct 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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?
|

October 31st, 2006, 02:59 AM
|
Registered User
|
|
Join Date: Oct 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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.....
|

October 31st, 2006, 05:08 AM
|
Registered User
|
|
Join Date: Sep 2006
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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)
|

October 31st, 2006, 11:03 AM
|
Registered User
|
|
Join Date: Oct 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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!
|

October 31st, 2006, 05:02 PM
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|

October 31st, 2006, 09:34 PM
|
Registered User
|
|
Join Date: Oct 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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....
|

October 31st, 2006, 10:31 PM
|
Friend of Wrox
|
|
Join Date: Jun 2003
Posts: 917
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
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
|
|
 |