插入数据突然停止 [英] Insert Data stop suddenly

问题描述

亲爱的所有人

突然在我的软件或mysql服务器中没有任何更改时，从我的软件(C#+ Vs2005 + .Net Connector)插入数据时出现以下错误:

MySql.Data.MySqlClient.MySqlException未处理
Message =命令执行期间遇到致命错误."
Source ="System.Data"
ErrorCode = -2147467259
数= 0

而且在测试过程中，它再次无缘无故地工作了一次，然后再次停止了！
任何帮助请

谢谢
bye

dear all

suddenly without any change in my soft or mysql server i got the following error while inserting data from my software (C# + Vs2005 + .Net Connector)

MySql.Data.MySqlClient.MySqlException was unhandled
Message="Fatal error encountered during command execution."
Source="System.Data"
ErrorCode=-2147467259
Number=0

but also while testing it worked again once without any reason then re stopped again !!!

any help please

thanks
bye

推荐答案

要做的第一件事就是重现该问题.如果可以的话，使它每次都实现.

然后，尝试一下-在您的软件中捕获块并捕获异常！查看详细信息，它应该可以帮助您找出问题所在.根据您的告诉，没有足够的信息.

The first thing you need to do it reproduce the problem. Make it happen every time if you can.

Then, put some try - catch blocks in your software and catch the exception! Look at the detail and it should help you to find out what the problem is. From what you have told us, there just isn''t enough information.

请参阅 [ ^ ].

也许与INSERT SQL语句的外观有关.
每个INSERT可能不同?

Maybe it has something to do with how your INSERT SQL statement looks.
It probably varies on each INSERT ?

这篇关于插入数据突然停止的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！