ORA-12154: TNS:could not resolve the connect identifier specified

[reijk317]

I hope some can help me.

I have a dashboard with a OLEdb connection (I also tried it with an ODBC connection).

When I reload this dashboard there is no problem, it reloads fine. But when I reload I by using Qlikview Management Console I get a error: ORA-12154: TNS:could not resolve the connect identifier specified

I don't understand this.  If there is a problem with TNS I would expect that I get also an error with reloading it in the dashboard.

[kaushiknsolanki]

Hi, You should create a system DSN (ODBC Connection) instead of User DSN.

This should solve your problem.

[reijk317]

Thanks, but we do have an system DNS

[kaushiknsolanki · Accepted solution]

In that case try creating the environmental variable for TNS entry, like below.

Set the TNS_Admin environment variable if it is not set

• Navigate to Control Panel > System
• Select Advanced System Settings
• In the Advanced tab, select Environment Variables
• Under System Variables, click New
• In the Variable name text box, type TNS_ADMIN
• In the Variable value text box, type the location of the TNSNames.ora file
• Click OK to add the variable
• Restart the server