Hello,

The site gives me an error on this part, but I can't find the error:

create procedure {databaseOwner}[{objectQualifier}DNNModuleProgramming_VB_InsertGue stbookEntry]

@ModuleId INT,
@submitterName NVARCHAR(255),
@submitterWebsite NVARCHAR(255),
@submitterComment NTEXT,
@submissionDate DATETIME,
@isApproved BIT
AS
INSERT INTO {datebaseOwner}[{objectQualifier}DNNModuleProgramming_VB_Guestbook]
(ModuleId, submitterName, submitterWebsite, submitterComment, submissionDate, isApproved)
VALUES
(@ModuleId, @submitterName, @submitterWebsite, @submitterComment, @submissionDate, @isApproved)

GO

Error message:
System.Data.SqlClient.SqlException: Incorrect syntax near '}'. at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(S tring SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(Stri ng Script, Boolean UseTransactions) create procedure dbo.[DNNModuleProgramming_VB_InsertGuestbookEntry] @ModuleId INT, @submitterName NVARCHAR(255), @submitterWebsite NVARCHAR(255), @submitterComment NTEXT, @submissionDate DATETIME, @isApproved BIT AS INSERT INTO {datebaseOwner}[DNNModuleProgramming_VB_Guestbook] (ModuleId, submitterName, submitterWebsite, submitterComment, submissionDate, isApproved) VALUES (@ModuleId, @submitterName, @submitterWebsite, @submitterComment, @submissionDate, @isApproved)
--

I see that the stored procedure dbo.DNNModuleProgramming_VB_InsertGuestbookEntry is not created. The others are OK.

PLease help
DMitar

p.s. Strange! There is not empty space " " in the word Guestbook here:
create procedure {datebaseOwner}[{objectQualifier}DNNModuleProgramming_VB_InsertGue stbookEntry]

When i get in Edit Mode in Forum, there's not space between "e" and "s" on the word Guestbook. When I click "Save" in my browser I see:
{datebaseOwner}[{objectQualifier}DNNModuleProgramming_VB_InsertGue stbookEntry]
---

Also I named module GuestBook_vb except GuestbookVB as it's in the book example. I suppose it doesn't matter at all as i strictly check everywhere the the name is correct and i have no errors in VSTO 2008 in the project files.

I also get this message when i try to test/add the module:

Error: Guestbook1 is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException : Could not load type 'WroxModules.GuestBook_vb.ViewGuestBook_vb'. ---> System.Web.HttpParseException: Could not load type 'WroxModules.GuestBook_vb.ViewGuestBook_vb'. ---> System.Web.HttpParseException: Could not load type 'WroxModules.GuestBook_vb.ViewGuestBook_vb'. ---> System.Web.HttpException: Could not load type 'WroxModules.GuestBook_vb.ViewGuestBook_vb'. at System.Web.UI.TemplateParser.GetType(String typeName, Boolean ignoreCase, Boolean throwOnError) at System.Web.UI.TemplateParser.ProcessInheritsAttrib ute(String baseTypeName, String codeFileBaseTypeName, String src, Assembly assembly) at System.Web.UI.TemplateParser.PostProcessMainDirect iveAttributes(IDictionary parseData) --- End of inner exception stack trace --- at System.Web.UI.TemplateParser.ProcessException(Exce ption ex) at System.Web.UI.TemplateParser.ParseStringInternal(S tring text, Encoding fileEncoding) at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding) --- End of inner exception stack trace --- at System.Web.UI.TemplateParser.ParseString(String text, VirtualPath virtualPath, Encoding fileEncoding) at System.Web.UI.TemplateParser.ParseFile(String physicalPath, VirtualPath virtualPath) at System.Web.UI.TemplateParser.ParseInternal() at System.Web.UI.TemplateParser.Parse() at System.Web.Compilation.BaseTemplateBuildProvider.g et_CodeCompilerType() at System.Web.Compilation.BuildProvider.GetCompilerTy peFromBuildProvider(BuildProvider buildProvider) at System.Web.Compilation.BuildProvidersCompiler.Proc essBuildProviders() at System.Web.Compilation.BuildProvidersCompiler.Perf ormBuild() at System.Web.Compilation.BuildManager.CompileWebFile (VirtualPath virtualPath) at System.Web.Compilation.BuildManager.GetVPathBuildR esultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.Compilation.BuildManager.GetVPathBuildR esultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile) at System.Web.UI.TemplateControl.LoadControl(VirtualP ath virtualPath) at System.Web.UI.TemplateControl.LoadControl(String virtualPath) at DotNetNuke.UI.ControlUtilities.LoadControl[T](TemplateControl containerControl, String ControlSrc) at DotNetNuke.UI.Modules.ModuleHost.LoadModuleControl () --- End of inner exception stack trace ---

For the application error, have a look and make sure that your .dll file is in the /bin folder of the DNN installation.

For the SQL Script issue, take a look at the query in SSMS, it looks like there is some formatting issue with the SQL.

__________________
Mitchel Sellers
Microsoft C# MVP, MCITP
Director of Development
IowaComputerGurus Inc.

My blog for .NET and DotNetNuke info

Author of "Professional DotNetNuke Module Programming"

Tech Editor on "Visual Studio 2010 six-in-one" and "Pro C# 4.0"

Thanks for your answer.

For the application error - OK, i missed the dll and it's ok now.

For the SQL error - I'm new to SQL Server Management Studio. I don't understand what you mean by take a look at the query in SSMS? Yes, it's kind of format error, do you mean to start the query script with SSMS? If yes, can you give me some short steps how to do it correctly?

Thanks in advance
DMitar

Please help me SSMS, where i have to take a look at?

if this hasn't been solved, there is a typo in your script:
create procedure dbo.[DNNModuleProgramming_VB_InsertGuestbookEntry] @ModuleId INT, @submitterName NVARCHAR(255), @submitterWebsite NVARCHAR(255), @submitterComment NTEXT, @submissionDate DATETIME, @isApproved BIT AS INSERT INTO {datebaseOwner}[DNNModuleProgramming_VB_Guestbook] (ModuleId, submitterName, submitterWebsite, submitterComment, submissionDate, isApproved) VALUES (@ModuleId, @submitterName, @submitterWebsite, @submitterComment, @submissionDate, @isApproved)

that should be {databaseOwner} not datebase