Forgive me for being such a newbie. I'm not an experience DNN developer and I was trying to do the "Hello World" tutorial from the Professional DotNetNuke 4 book. I'm using DNN 4.5.1 and I downloaded the Starter Kit for 4.5.1. Using VS 2005 Pro.
I followed all the steps including making the SQL 2000 database and updating the web.config file. The DNN portal that gets installed works fine. However when I create the "HelloWorld" module and then add it to a page, this is what I get.
Error: Hello World is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.YourCompany_GetHelloWorlds' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.YourCompany_GetHelloWorlds' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSetInternal(SqlConnection connection, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName, Boolean includeReturnValueParameter) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.GetSpParameterSet(String connectionString, String spName) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at YourCompany.Modules.HelloWorld.SqlDataProvider.GetHelloWorlds(Int32 ModuleId) in http://server/DotNetNukeKS3/App_Code/HelloWorld/SqlDataProvider.vb:line 130 at YourCompany.Modules.HelloWorld.HelloWorldController.GetHelloWorlds(Int32 ModuleId) in http://server/DotNetNukeKS3/App_Code/HelloWorld/HelloWorldController.vb:line 59 at YourCompany.Modules.HelloWorld.ViewHelloWorld.Page_Load(Object sender, EventArgs e) in http://server/DotNetNukeKS3/DesktopModules/HelloWorld/ViewHelloWorld.ascx.vb:line 70 --- End of inner exception stack trace ---
Someone has got have gotten this darn thing to work right before! Can anyone shed some light on this dimwit?
Thanks,
Paul