Hi,

I'm using DNN 4.3.3 on a Windows XP

I'm trying to do the 'step by ste' posted by Shan Walker : 'Dotnetnuke 4.3 StarterKit and Item Template'

I have a big problemafeter execution the script (pasted from 01.00.00SQLProvider'.
I have no error when i execute it but after when i wand to add the widget module on my page i have this error :

Error: widget is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.YourCompany_Getwidgets' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.YourCompany_Getwidgets' 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.widget.SqlDataProvider.Getwidgets(Int32 ModuleId) at YourCompany.Modules.widget.widgetController.Getwidgets(Int32 ModuleId) at YourCompany.Modules.widget.Viewwidget.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

I don't understand why ! Can you help me ?

(In a script they say i have to replace dbowner and objectQualifier but i don't know the walue i have to put.)

Thanks

Anthony

Where did you run the script?
You are supposed to run the entire contents of the 01.00.00SQLProvider script from the Host - SQL box.
You have to check 'Run as script' first !
Then you don't need to change the dbowner and objectQualifier.

By the way, in 4.3.3 this has changed. You can read about in a blog by Michael Washington

Argh !

It was only a little error in my <appsetting> in the webconfig file, so database name was not the same....

Thanks all