Hello!

Has anyone some experience with clr stored procedures and dnn?

My problem:
I wrote a clr stored procedure. I am able to execute this clr stored procedure with Sql server management studio, I am able to execute this clr stored procedure with dnns sql area in the host menu.
But when I want to execute it in my c# code with SqlHelper.ExecuteReader following message appears:

DotNetNuke.Services.Exceptions.ModuleLoadException: The stored procedure 'dbo.STAGE4US_CD_Tags_Search' doesn't exist. ---> System.InvalidOperationException: The stored procedure 'dbo.STAGE4US_CD_Tags_Search' 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[]

I am helpless! What could be the reason????

Thanks in advance

Torres

I think so - but I am not very experienced with SQL Server.

I can execute the script in the sql menu this way:

exec dbo.procedurename.....

And it works. So I think DNN has the permissions!? If I am wrong, could you please tell me, what permission I have to grant? I am using "Integrated security".

Thank you very much

Martin

Nevertheless. It doesn't work.

Withoud dbo the error message is:

The stored procedure 'STAGE4US_CD_Tags_Search' doesn't exist.

:-( Why???