Skip to main content
Do More with Qlik - Qlik Cloud Analytics Recap and Getting Started, June 19: REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connection issue with oracle DB


I'm trying to connect qlikview with oracle DB but i'm getting following error:

Connection Test Failed

SQL##f - SqlState: S1000, ErrorCode: 12504, ErrorMsg: [Oracle][ODBC][Ora]ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA.

Things i did:

1. Installed Qlikview 2. Installed Oracle Client11g 3. Installed oracle SQL developer

Please do let me if any information is required to assist me


13 Replies

Hi mithun,

You must Install the ODBC Driver, and then configure the Data origins. You might have the ODBC Client already, so le last step you're missing is setup the connection.

You must search for the "ODBC Data source configuration" and then put you're Database connection information on it.

Please let my know if you need more assitance.

Best regards,


PS: These two articles and video should help you figure it out.

Using the Oracle ODBC Driver

Create ODBC Data Source Connection for oracle in Windows - YouTube

Partner - Champion III
Partner - Champion III

It is actually an Oracle configuration problem and if you Google the error message you will be lead into where you can find helpful advice.

The part of the error message you should Google is:

ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA.


Hi Mithun,

Check your TNS directory  file once

Contributor II
Contributor II

Hello mithun!

verifyning :

1_ tnsname


2_ Data Source ODBC: system  DNS. Test Connection


3_ Create string of connection QlikView (user ID and pass)




Partner - Champion III
Partner - Champion III

The important thing is to get your TNSNAMES.ORA text configuration-file correctly. Ask your Oracle DBA how it should look like. The pure installation of Oracle's software will not configure this correctly so it has to be replaced or changed so it works against your Oracle database.

The location of the tnsnames.ora is:


and $ORACLE_HOME is an environment variable in Windows that has a value almost like this:


depending on your client Oracle ODBC installation and what was specified.

Master II
Master II


It could be two reasons:

1. Coonnection user doesn't have access on database or tables

2. TNS entries could be wrong.

Hope this will help you.

Not applicable

Try checking the Force 32 Bit box before setting up the ODBC Connection.  Your oracle server may not be 64 bit

Not applicable

Thanks guys for your prompt response...

But still i'm not able to resolve the issue

1. i have tns file place in an exact path with .ORA format ie. tnsnames.ora

2. tried to do by checking Force 32bit also

One thing is i'm able to fetch data in DB by using the same configuration details but unable to connect to qlikview

please do let me know if any further information is required

Master II
Master II

Can you provide the screens of how you created the connection?