Direct Discovery for mySQL

[#1]

Hi,

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?

Regards,

CS Khoo

[rbecher]

1. Select the Tracing tab in the ODBC Data Source Administrator dialog box.
2. Change the Log File Path or leave the default path indicated.
3. Click the Start Tracing Now button.

[#3]

Thanks everyone. I solved the problem.

Bill's ans is correct. I did apply this statement

SET DirectIdentifierQuoteChar='``';

But i changed the quote char. =P

Sorry.

Thanks anyway!!!!!!!!!!!!!