Phoenix130481
Programmer
Hello,
as you can see above i get this message when i want to start a stored procedure. i have grant the execute right to the stored procedure but i get then this error. below you can see the full error message:
ystem.Data.SqlClient.SqlException: Das erteilte oder aufgehobene EXECUTE-Privileg ist mit dem Objekt nicht kompatibel.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at OPAprojekt.DatabaseConnection.ExecuteStoredProcedure(StoredProcedureBasisKlasse storedProcedure, SqlTransaction transaction) in e:\inetpub\ 107
at OPAprojekt.DatabaseConnection.ExecuteNonQuery(StoredProcedureBasisKlasse storedProcedure) in e:\inetpub\ 96
at OPAprojekt.WebForm2.Button2_Click(Object sender, EventArgs e) in e:\inetpub\ 134
does anyone has a idea waht that might be? i think it sounds like a programming error...
i am thankful for every idea!
basti
as you can see above i get this message when i want to start a stored procedure. i have grant the execute right to the stored procedure but i get then this error. below you can see the full error message:
ystem.Data.SqlClient.SqlException: Das erteilte oder aufgehobene EXECUTE-Privileg ist mit dem Objekt nicht kompatibel.
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at OPAprojekt.DatabaseConnection.ExecuteStoredProcedure(StoredProcedureBasisKlasse storedProcedure, SqlTransaction transaction) in e:\inetpub\ 107
at OPAprojekt.DatabaseConnection.ExecuteNonQuery(StoredProcedureBasisKlasse storedProcedure) in e:\inetpub\ 96
at OPAprojekt.WebForm2.Button2_Click(Object sender, EventArgs e) in e:\inetpub\ 134
does anyone has a idea waht that might be? i think it sounds like a programming error...
i am thankful for every idea!
basti