'LIMIT 1' is not standard SQL (it is a MySQL extension)
and ODBC might be choking on this.
Some ODBC drivers have 'passthrough' capabilities
that don't try to parse the SQL statement, and thus
would allow this non-standard SQL statement to pass
through directly to the MySQL server.
I don't know whether the MySQL ODBC drivers have
this capability or not since I don't use it, but if you
want to test this theory just delete the 'LIMIT 1' from
There is nothing wrong with your syntax
(SELECT * FROM Thomas1).
The syntax error message is a red herring. Ignore it -- you
probably have something more seriously wrong.
I'm thinking you have an incompatibility btn the
versions of software you are using, or something's
not installed right. Version 3.51 is supposed to be stable,
as well as MySQL 3.23.58, so those pgms are probably OK.
I have contacted my server admin.
One other thing I forgot to mention.
ADO cannot resolve the recordcount of returned recordsets.
I open a recordset that contains 22 records, I can iterrate through them, but recordcount always equates to -1.
I'm sure this is related as I have never had this problem either.
Thank you for your help.
I'm sure your post will help them identify the problem.