Bug #70158 select error sqlstate -37000 --used powerbuilder12.5 and Mysql ODBC 5.2.4
Submitted: 27 Aug 2013 5:55 Modified: 3 Feb 2014 17:54
Reporter: Aji Mon Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Errors Severity:S1 (Critical)
Version: OS:Windows (XP - sp 3)
Assigned to: CPU Architecture:Any

[27 Aug 2013 5:55] Aji Mon 
Description:
I am getting error page while running my program with Mysql ODBC connection 5.2.4. I am using Workbench 6.0 for Windows 32 Bit.

Error details are,

select error :SQLSTATE= 37000 [MySQL][ODBC5.2(a) Driver][mysqld]5.5.16] you have an error in SQL syntax;check the manual that corresponds that your mysql server version for the right syntax to use near '.""ouc_desc","outlet"."ou_code" from "outlet" at line 1

How to repeat:
You can repeat the eeror by connecting Mysql ODBC connection 5.2.4 with Workbench 6.0 for Windows 32 Bit . You can check with powerbuilder 10.5/12.5 check with query as select count(*) from....... query shold be aded with powerbuilder source...
[27 Aug 2013 6:07] MySQL Verification Team 
could this be related to http://bugs.mysql.com/bug.php?id=70121 ?
[26 Oct 2013 13:30] Aji Mon 
thank you for your support..now the issue resolved....
[30 Jan 2014 17:00] Sveta Smirnova 
Thank you for the feedback.

So this is PowerBuilder issue. Closed as "Not a Bug".
[3 Feb 2014 17:54] Aji Mon 
problem solved...i did some modifications in my.ini