从ASP.NET 2 MySQL的存储过程调用抛出使用过程异常机构 [英] MySQL stored procedure call from ASP.NET 2 throws Use Procedure bodies exception

问题描述

您好我有以下情形。我打电话从我的.NET应用2存储过程到MySQL 5.x的。所有的存储过程有参数和他们很好地工作的两个例外，它抛出以下异常（仅当部署到生产）：

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

推荐答案

确定解决。我经过DBNULL.Value因为它没有明显喜欢的参数。

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

这篇关于从ASP.NET 2 MySQL的存储过程调用抛出使用过程异常机构的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！