Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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!!!!!!!!!!!!!