Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

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


Hi

How do I resolve this: ErrorSource: OraOLEDB, ErrorMsg: ORA-12154: TNS:could not resolve the connect identifier specified.

Trying to connect to an oracle db

3 Replies
Or
Valued Contributor II

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

Supply a correct, working TNS that appears in your tnsnames.ora file, or add the one you are using to that file.

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

I suggest to involve your DBA t do the same.

Regards

ASHFAQ

diego_a_barboza
New Contributor III

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

In order to solve any issue on the Oracle side, try to connect using Toad for SQL, SQL Navigator or any other software that allows you to connect to that database.

Once that you are sure that the Oracle client is properly set up, that the TNSNames is working fine so, reboot the server and try again (or at least, restart services) that will enable QV to work with Oracle.

Regards.