7 Replies Latest reply on Aug 19, 2013 8:55 AM by JohnGoodwin

    Loading Data from Oracle into Essbase using Data Source type SQL

    NaveenKumar Dasu

      Hi,

      I am trying to load the data into one of my Database in a Application  in Essbase using Data Source Type SQL. I selected the SQL and selected the Rule-file and provided the correct Username and password of the Oracle Schema. I am getting the following Error.

       

      Reading Rule SQL Information For Database [PLC-E]

      Reading Rules From Rule Object For Database [PLC-E]

      Cannot read SQL driver name for [] from [ODBC.INI]

      Connection String is generated

      Connection String is [DSN=;UID=...;PWD=...;]

      SELECT Statement [SELECT * ] is generated

      ODBC Layer Error: [IM002] ==> [[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]

      ODBC Layer Error: Native Error code [0]

      Failed to Establish Connection With SQL Database Server.  See log for more information

      Unexpected Essbase error 1021001

       

      I have created the ODBC  Data Source for the schema from where i am pulling the data but getting the error as mentioned above. Do i need to add anything anywhere to pull the data.Any help is highly appreciated.

       

       

      Regards,

      Naveen