Error trying to connect to ODBC.

[#1]

Hi All,

we have an application which fetches data from Oracle EDW. when i open the application on server and reload, it runs fine. but when try to run the same application through a  base load in QEMC it fails with below error.

Error: ErrorSource: OraOLEDB, ErrorMsg: ORA-12154: TNS:could not resolve the connect identifier specified.

This application used to run all fine through QEMC before.

Can anyone figure out what might be the issue? Please suggest.PFA log file for the same.

[#2]

Hi,

Plz check the TNS name or Connection String in .ora file

[tresesco]

Check this link: ORA-12154: TNS tips

[Chip_Matejowsky · Accepted solution]

Probably not a QlikView issue; more of a configuration issue. See this post for further information.

This particular error message is a very general error message and can happen for quite a number of reasons. For general understanding of the error, you can review oracle documentation like this http://ora-12154.ora-code.com/

In SQL Server Linked Server, it could indicate a few things (not limited to)–

1. 1.       SQL Server (and oracle net libraries) is not able to get the TNS alias from tnsnames.ora file.
2. 2.       Something is wrong with the way the alias is created in the tnsnames.ora file (incorrect syntax)
3. 3.       TNS alias could not be resolved into a connect descriptor

[Giuseppe_Novello]

Jyothi,

It seems to be a Oracle issue, if you do a simple Google search you can find thousands of people with same issue. Have you tried with ODBC connection, and if you try that make sure that you are setting up a system DNS not user DNS.

Gio

[#6]

Thank You Everyone.

Issue was, tns file did not have the Datasource entry.

now it is resolved by DBA team.

[kshitiz7]

HI Jyothi KV,

Can you Please tell me what your DBA team did so that i can recommend the same to my Oracle DBA team .

Regards,

Kshitiz