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

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.

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?

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

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)

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!

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

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

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