I'm an experienced Classic ASP programmer who is new to .NET. I would like to use the diary organizer for an internal office project. However, I'm using Vista, IIS, SQL2005, and Visual Studio Express 2008. (Although, the code in the book was written prior to all of these updates, I believe 2.0 code should be able to work on with these platforms.)
I was able to get the membership to work with SQL 2005 and re-created the diary database in SQL 2005 and connected successfully to the database in VS08. however, when I pull up the login page and try to login I receive the following error:
Could not find stored procedure 'GetRecentDiaryEntries'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Could not find stored procedure 'GetRecentDiaryEntries'.
Line 216: diaryDBConn.Open()
Line 217: Dim entrySQLDR As SqlDataReader = sqlCmd.ExecuteReader(CommandBehavior.CloseConnecti on)
Line 218: sqlCmd = Nothing
Line 219: Return entrySQLDR
Source File: C:\inetpub\wwwroot\onlinediary\App_Code\DiaryEntry .vb
I also receive a stored procedure error (similar to this) when registering as a new member.
What should I do now to resolve this issue and get the program functioning using the latest MS software. The book didn't say the program used stored procedures within the SQL database so I'm unsure what to do. PLEASE HELP. I'm using instant results as way to get better aquainted with the language.