topic Re: How to connect oracle database with QlikView Report ? in QlikView

How to connect oracle database with QlikView Report ?

ashish1504 — Mon, 26 Jan 2026 21:26:37 GMT

I have tried to make connection using OLEDB between Oracle db and QlikView. But qlikview is unable to read tnsnames.ora file.

I think i am unable to place the file on proper directory. Can anyone help me with this

Thank you so much.

Below is the error msg.

Re: How to connect oracle database with QlikView Report ?

Ray_Strother — Tue, 22 Nov 2022 14:21:37 GMT

Hello ,

The links below should help you successfully connect to your database. The error passed back isn't from Qlikview , but rather it's a system error.

1. Create an Oracle connection

https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Oracle/Create-Oracle-connection.htm

2. How to create ODBC connection to Oracle

https://community.qlik.com/t5/QlikView-App-Dev/How-to-create-ODBC-connection-to-Oracle/td-p/788946

3. http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm

Re: How to connect oracle database with QlikView Report ?

Chip_Matejowsky — Fri, 02 Dec 2022 14:36:53 GMT

Hi @ashish1504,

I agree with @Ray_Strother that this error isn't a QlikView error per se.

From http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm:

The ORA-12154 is a very common error, always related to your local copy of the tnsnames.ora file, your listener configuration and your database name aliases.

Make sure that your listener is listening for the same service name that you are using.
Check your global_name setting with this SQL:
select * from global_name;

The query value should match your init.ora parms for db_name and db_domain, You can change the global_name with an ALTER DATABASE command, as follows:

alter database rename global_name to xxx;

Suggest that you reach out to your Oracle DBA for further assistance.

Best Regards