Hi. I'm new to mySql and I want to use it in a LabView (graphical programming from National Instruments) program. For communication I chose to use ADO (specifically myOLEDB). So, to add data I want to do the next:
1. Create command object with the proper SQL INSERT statement, with the respective positional parameters. Example: "insert test1 (numero,nombre) values (?,?)"
2. Create and add parameters
3. Set parameter values
4. Execute command
The problem is that the "execute" method gives error -2147217900, "one or more errors when processing command".
I have seen some VB examples where the positional markers are not "?" but "@name", for example. I suspect that I could have a syntax error, so I would like to know if it is right to use the "?" and if there are any requeriments regarding paramenter names.
If you want to take a look or if you have experience with LabView, check the diagram:
http://www2.udec.cl/~danirami/ADOproblem.jpg
Any ideas, suggestions or documentation greatly appreciated. (sticky on this since monday)
Thank you,
Daniel Ramirez
UdeC, Chile