Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
I need your help.
I got the error message from Qlik Oracle Connector & Qlik ODBC Connector.
ERROR [HY000] [Qlik][OracleOCI] (3000) Oracle Caller Interface: ORA-12547: TNS:lost contact
The below test is succeed.
- SQL Developer connection
- Window ODBC 64 bit Test Connection
I can not find the solutions.
What should I request to Oracle DBA?
Best Regard.
hanna.choi
Hello @hanna_choi , thanks for posting!
Can you test the actual data retrieval outside of Qlik?
https://community.qlik.com/t5/Knowledge/How-to-fetch-data-via-ODBC-DSN-without-using-Qlik-Products/t...
https://community.qlik.com/t5/Knowledge/How-to-fetch-data-with-ODBC-DSN-connections-using-Powershell...
Sometimes we see scenarios where the Test Connection function works but the user does not have access to the actual data. This would be a good test to see if the same account can retrieve the data from that server.