corrupted table column names:
This is a bug in mySQL ODBC driver 5.1.7 (24 August 2010)
Solution:
Download a different mySQL ODBC driver.
Bug should be fixed in mySQL ODBC driver 5.1.8.
More info:
http://download.oracle.c...tor-odbc-news-5-1-8.html ORG. TEXT:
C.3.1. Changes in MySQL Connector/ODBC 5.1.8 (Not yet released)
Functionality added or changed:
•Documentation in .CHM and .HLP format has been removed from the distribution. (Bug#56232)
Bugs fixed:
•SQLDescribeCol and SQLColAttribute could not be called before SQLExecute, if the query was parameterized and not all parameters were bound.
Note, MSDN states that “For performance reasons, an application should not call SQLColAttribute/SQLDescribeCol before executing a statement.” However, it should still be possible to do so if performance reasons are not paramount. (Bug#56717)
•When SQLNumResultCols() was called between SQLPrepare() and SQLExecute() the driver ran SET @@sql_select_limit=1, which limited the resultset to just one row. (Bug#56677)