1 Reply Latest reply on Jul 3, 2018 8:36 AM by SonPat99

    OBIEE12C SQL server cloud connectivity issue

    user8680861

      Hi Experts,

      we are trying to create reports in OBIEE12c by connecting to the SQL server cloud instance via ODBC. While creating the report the following error is occurring. Do we need to do any specific ODBC related settings in OBI12 environment to connect to the SQL server ?

       

       

       

      View Display Error
      Odbc driver returned an error (SQLExecDirectW).
      http://belexroad-test.bel.com:9502/analytics/res/v-RS96Z2oBs2o/sk_blafp/common/errorminus.gif  Error Details
      Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
      State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
      State: HY000. Code: 16001. [nQSError: 16001] ODBC error state: IM002 code: 0 message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (HY000)
      SQL Issued: SELECT 0 s_0, "BajajSaarthiAnalytics"."MFR_Store"."Branch_code" s_1 FROM "BajajSaarthiAnalytics" FETCH FIRST 65001 ROWS ONLY
      View Display Error
      Odbc driver returned an error (SQLExecDirectW).
      http://belexroad-test.bel.com:9502/analytics/res/v-RS96Z2oBs2o/sk_blafp/common/errorminus.gif  Error Details
      Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
      State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
      State: HY000. Code: 16001. [nQSError: 16001] ODBC error state: IM002 code: 0 message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. (HY000)
      SQL Issued: SELECT 0 s_0, "BajajSaarthiAnalytics"."MFR_Store"."Branch_code" s_1 FROM "BajajSaarthiAnalytics" FETCH FIRST 65001 ROWS ONLY