Environment: ASP.NET, AJAX.NET and MySQL DB
I got error return when using one of the form written in AJAX.NET when calling MySQL Stored Procedure
Sys.WebForms.PageRequestManagerServerErrorException: an unknow error occured while processing the request on the server. the status code returned from the server was: 500
Well, after check around i found out that the problem is in the MySQL Stored Procedure case sensitive issue. Change the case and problem solved!
2 comments:
hi,
i have the same problem... but, what do you mean with "change the case"...
change the case to upper?? lower??...
in name of columns or resulting rows??
It's case sensitive, in situation, it happen to the MySQL Stored Procedure case. So, i change to exactly the same case that using in Stored Procedure.
For instant, my stored procedure name is "sp_CheckAccessibility", so, i have to use exact case to call this stored procedure. Hope this help.
Post a Comment