Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE12C SQL server cloud connectivity issue

Received Response
1
Views
1
Comments
user8680861
user8680861 Rank 2 - Community Beginner
edited Aug 13, 2024 5:47PM in Oracle Analytics Forum

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 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).
  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

Answers