MySQL stored procedure call from ASP.NET 2 throws Use Procedure bodies exception

Question

Hi I have the following scenario. I am calling stored procedures to MySQL 5.x from my .NET 2 application. All stored procedures have parameters and they work fine with the exception of two which throw the following exception (only when deployed to production):

"When calling stored procedure and 'Use Procedure bodies' is false, all parameters must have their type explicitly set.

This only occurs on the "production" environment. On my development machine, everything works fine in all cases.

Any ideas? Thanks in advance, Tim

Answer 1

OK solved. I was passing DBNULL.Value as a parameter which it did not like apparently.

Answer 2

I concur, I ran into this very same issue and it was the same for me. Thanks for including your resolution, it helped me solve this issue!