Connection issue with oracle DB

[#1]

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!

[andrespa]

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]

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]

Hello mithun!

verifyning :

1_ tnsname

2_ Data Source ODBC: system  DNS. Test Connection

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

Try

Regards.

[petter]

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]

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.

[#8]

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

[#9]

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]

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