Wrong SQL statement

Hi

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 [at] m.gmane.org
Santiago Burbano [ Mo, 21 März 2005 02:01 ] [ ID #705918 ]
Datenbanken » gmane.comp.db.mysql.odbc » Wrong SQL statement

Vorheriges Thema: Error message, Can I ask u How do I establish a remote connection, from System A to sytem B?
Nächstes Thema: Unable to find myodbc3d.dll