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?