Need help with the Mysql database setting.
The mysql database and the BIEE 11g server are located in the same Linux server. I installed the unixODBC,and the unixODBC setting went well as I can use isql command to connect to mysql. I also added a new database in repository,but in Answer,the query returned following error:
[unixODBC][MySQL][ODBC 5.1 Driver][mysqld-5.5.29]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 '"area_org_name" as c1 from "en_org_dimt0" T43766' at line 1