topic Error trying to connect to ODBC. in QlikView

Error trying to connect to ODBC.

Thu, 23 Oct 2014 09:34:24 GMT

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.

Re: Error trying to connect to ODBC.

Thu, 23 Oct 2014 09:54:13 GMT

Hi,

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

Re: Error trying to connect to ODBC.

tresB — Thu, 23 Oct 2014 09:58:03 GMT

Check this link: ORA-12154: TNS tips

Re: Error trying to connect to ODBC.

Chip_Matejowsky — Thu, 23 Oct 2014 17:00:29 GMT

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

Re: Error trying to connect to ODBC.

Giuseppe_Novello — Thu, 23 Oct 2014 17:21:28 GMT

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

Re: Error trying to connect to ODBC.

Wed, 29 Oct 2014 22:28:21 GMT

Thank You Everyone.

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

now it is resolved by DBA team.

Re: Error trying to connect to ODBC.

kshitiz7 — Tue, 10 Mar 2015 11:05:46 GMT

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