Administrator
  •  Admin
  • Advanced Member Topic Starter
2010-10-19T14:40:00Z
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)

Administrator
  •  Admin
  • Advanced Member Topic Starter
2010-12-08T12:18:00Z
According to our users, mySQL ODBC driver 5.1.8 release did not fix the issue
Administrator
  •  Admin
  • Advanced Member Topic Starter
2011-01-25T15:00:00Z
We have implemented a workaround in GeniusConnect 5.0.0.3
http://www.geniusconnect...les/GeniusConnect/2/3/4/