ExecuteNonQuery

  • Thread starter Thread starter Lorenz Ingold
  • Start date Start date
L

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?
 
¤ 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)
 
¤ 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
 
Back
Top