OBIEE12C SQL server cloud connectivity issue

Question

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).
  Error DetailsError Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: 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).  Error DetailsError Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: 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

SonPat99 · Answer

Did you tried creating a System DSN?