Home All Groups Group Topic Archive Search About
Author
17 Feb 2006 12:41 PM
Lorenz Ingold
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?

Author
17 Feb 2006 3:12 PM
Paul Clement
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)
Author
18 Feb 2006 9:41 PM
Otis Mukinfus
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:
>
>¤ 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)
You're on the right track, Paul.  Sounds like a typo in a parameter to
me.

Otis Mukinfus
http://www.otismukinfus.com
http://www.tomchilders.com

AddThis Social Bookmark Button