|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
ExecuteNonQueryIn .NET 2.0 I have the instruction
mySqlCommand.ExecuteNonQuery() This throws an error, not the first time since object creation, but only from the second time on. The error is (first in German, as our system is German): "-2146232060 .Net SqlClient Data Provider Die vorbereitete Anweisung mit dem Handle 1 konnte nicht gefunden werden." (this is in English something like: "Die prepared instruction with the handle 1 could not be found") What are possible causes of this error? On Fri, 17 Feb 2006 13:41:08 +0100, "Lorenz Ingold" <l.ing***@comteach.ch> wrote: ¤ In .NET 2.0 I have the instruction¤ mySqlCommand.ExecuteNonQuery() ¤ This throws an error, not the first time since object creation, but only ¤ from the second time on. The error is (first in German, as our system is ¤ German): ¤ "-2146232060 .Net SqlClient Data Provider Die vorbereitete Anweisung mit ¤ dem Handle 1 konnte nicht gefunden werden." ¤ ¤ (this is in English something like: "Die prepared instruction with the ¤ handle 1 could not be found") ¤ What are possible causes of this error? ¤ Does this action query use parameters? Could you post a code sample? Paul ~~~~ Microsoft MVP (Visual Basic) On Fri, 17 Feb 2006 09:12:11 -0600, Paul Clement
<UseAdddressAtEndofMess***@swspectrum.com> wrote: Show quote >On Fri, 17 Feb 2006 13:41:08 +0100, "Lorenz Ingold" <l.ing***@comteach.ch> wrote: You're on the right track, Paul. Sounds like a typo in a parameter to> >¤ In .NET 2.0 I have the instruction >¤ mySqlCommand.ExecuteNonQuery() >¤ This throws an error, not the first time since object creation, but only >¤ from the second time on. The error is (first in German, as our system is >¤ German): >¤ "-2146232060 .Net SqlClient Data Provider Die vorbereitete Anweisung mit >¤ dem Handle 1 konnte nicht gefunden werden." >¤ >¤ (this is in English something like: "Die prepared instruction with the >¤ handle 1 could not be found") >¤ What are possible causes of this error? >¤ > >Does this action query use parameters? Could you post a code sample? > > >Paul >~~~~ >Microsoft MVP (Visual Basic) me. Otis Mukinfus http://www.otismukinfus.com http://www.tomchilders.com |
|||||||||||||||||||||||