Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Laxmii
Contributor
Contributor
Friday

connection creation IN QV to ORACLE DB

Hi All,


ERROR : test connection failed because of an error in initializing provider.ORA-12154:TNS:could not resolve the connect identifier specified 

I'm getting this error while connecting to a oracle database from Qlikview , why this occuring even if tns file is configured and tried to connect using EZCONNECT method.

if anyone have idea about this , please help

77 Views
0 Likes
4 Replies
Or
MVP
MVP
Sunday

Sounds like it is perhaps not defined correctly. Are you able to connect to other environments from the TNS file? 

49 Views
0 Likes
Laxmii
Contributor
Contributor
Sunday
Author

In response to Or

There will be 2 TNS file isn't from our side and DB side . Which one you are mentioning?

 

46 Views
0 Likes
Or
MVP
MVP
yesterday

In response to Laxmii

Sorry, I don't understand your question. 

The TNS file should be available on the Qlik server based on the Oracle client settings. Qlik only sees one TNS file, and it doesn't see anything on the database server directly. 

16 Views
0 Likes
Laxmii
Contributor
Contributor
yesterday
Author

yes. We can connect it from Qliksense without any issues but the same we are getting error on qlikview

13 Views
0 Likes