11 Replies Latest reply: Jun 3, 2014 4:32 AM by Cs Khoo RSS

    Direct Discovery for mySQL



      I'm developing an application which required Direct Discovery. I tested using the MSSQL, I got no problem in developing the application. But now I need connect to another database type which is mySQL, but when I reload the script, error from the DIRECT QUERY statement.


      SQL##f - SqlState: 37000, ErrorCode: 1064, ErrorMsg: [MySQL][ODBC 5.3(w) Driver][mysqld-5.0.41-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[ServiceNo] FROM [branchs].[stuservice]' at line 1


      Please advice. Or anyone have the sample code for direct discovery in mySQL?



      CS Khoo