I have 2 stored procedures that I make a call to in my MVC app. First one adds rows to db, second one deletes some rows. Both the procedures work fine on the local machine. But on the remote server only Insert works. When I try to delete rows, I get error: An error occurred while processing your request.
Really you need to show a detailed error message. If you turn off custom errors on your live site, you should get a detailed stack trace of the error, which you should post here to help people diagnose your problem.
My guess is though that it's probably permissions based, as one of the stored procedures works. Ensure that the database user has execute permissions on the other stored procedure. It sounds obvious, but also check that the second stored procedure is present on the live site too.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments