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

Connection issue with oracle DB

Hi,

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

Thanks!

13 Replies
andrespa
Specialist
Specialist

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,

Andrés

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

https://msdn.microsoft.com/en-us/library/ca6axakh(v=vs.80).aspx

Using the Oracle ODBC Driver

Create ODBC Data Source Connection for oracle in Windows - YouTube

petter
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 community.oracle.com 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.

avinashelite

Hi Mithun,

Check your TNS directory  file once

rteco0131
Contributor II
Contributor II

Hello mithun!

verifyning :

1_ tnsname

Tnsname_2015.png

2_ Data Source ODBC: system  DNS. Test Connection

ODBC.png

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

StringQV.png

Try

Regards.

petter
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:

  $ORACLE_HOME\network\admin

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

c:\oracle\product\11.2....\xxxx  

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

qlikviewwizard
Master II
Master II

Hi,

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
Author

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

Not applicable
Author

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

qlikviewwizard
Master II
Master II

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