Hi Adef
I managed to get the module to work. The problem had something to do with the YourCompany_GuestBook table which i had to create manually. When i did create this table exactly to your specification in the tutorial and saved it as YourCompany_GuestBook , i noticed it was the only table in the dotnetnuke database that did not have a (dbo) extension appended to it. For example : Vendor (dbo), UsersOnline (dbo). I downloaded the source for the tutorial and found the 01.00.00.SqlDataProvider script.
I then deleted the YourCompany_GuestBook table which i initially created and ran the following part of the script in dotnetnuke sql command prompt.
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'{databaseOwner}[{objectQualifier}YourCompany_GuestBook]') and OBJECTPROPERTY(id, N'IsTable') = 1)
DROP TABLE {databaseOwner}[{objectQualifier}YourCompany_GuestBook]
GO
CREATE TABLE {databaseOwner}[{objectQualifier}YourCompany_GuestBook] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[ModuleID] [int] NULL ,
[Name] [nvarchar] (50) NULL ,
[Email] [nvarchar] (50) NULL ,
[Message] [nvarchar] (250) NULL ,
[DateEntered] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE {databaseOwner}[YourCompany_GuestBook] ADD
CONSTRAINT [PK_{objectQualifier}YourCompany_GuestBook] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO
After i ran the script a table with YourCompany_GuestBook (dbo) appeared in the dnn database and the module worked fine. I know i managed to get the module to work, but i don't understand how.
Why is it that when i created the table manually it did not work and it did not have the extension (dbo).
Can you enlighten me on this!
Kind Regards