@babitaku , please check the logs on the Oracle side to see what the account is coming in as. On successful attempts it may be coming through as the user configured via the ODBC Administrator console, whereas the user may be different coming from the built-in connector.
You can try to isolate this further by adding the service account to Oracle permissions as well as testing outside of Qlik: https://community.qlik.com/t5/Official-Support-Articles/How-to-fetch-data-via-ODBC-DSN-without-using...
You can also test by going directly to the connector package located here:
C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage
Once here, launch the QvOdbcConnectorPackage.exe and use Driver: Oracle.
Hope that helps!
To help users find verified answers, please don't forget to mark a correct resolution or answer to your problem or question as correct.
