从ASP.NET 2 MySQL的存储过程调用抛出使用过程异常机构

问题描述:

您好我有以下情形。我打电话从我的.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.