This discussion is archived
2 Replies Latest reply: Jan 28, 2013 5:47 PM by laoding RSS

MYSQL database issue

laoding Newbie
Currently Being Moderated
Hi,

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points