2 Replies Latest reply: Jan 28, 2013 7:47 PM by laoding RSS

    MYSQL database issue

    laoding
      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