ODBC driver returned an error (SQLExecDirectW)
So many times we may face this error.
It’s because of the down services of database in the database installed machine.
Click on Error details to view the type of error.
So the error throws the TNS: No listener
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS.
[nQSError: 17001] Oracle Error code: 12541, message: ORA-12541: TNS:no listener at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)
Go to the location of Database installed drive or Client.
Check the tsnnames.ora file and its entries.
Check the names which you connected to the database.
Go to command prompt, use the command “tnsping Gan”, and check the status of the database connection.
So the database not connecting the error shows TNS: has no listener.
Check with the database installed machine whether the services got down restart the services and refresh the BI.
Automatically it will get up and the reports will get display.