Wrong SQL statement
am 21.03.2005 02:01:57 von Santiago BurbanoHi
I'm trying to insert some records in a db through ADO and myODBC complains
about wrong SQL syntax.
Checking the logs, I see that the actual SQL statement that myODBC is
generating is:
INSERT INTO `a3nomedu`..`Trabajadores` ( COD_Trabajador) VALUES('000001')
Which is obviously wrong.
This is my setup:
Both client and server on same machine running WinXP SP2/MySQL 4.1.10/myODBC
3.51.11
Connection through fully configured DSN, with option=35.
Using server-side cursors, dynamic recordset and addnew/update methods.
Any idea about how to solve it?
TIA
Santiago
--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc@m.gmane.org