topic Re: Connection issue with oracle DB in QlikView

Connection issue with oracle DB

Thu, 08 Oct 2015 09:03:56 GMT

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!

Re: Connection issue with oracle DB

andrespa — Thu, 08 Oct 2015 13:21:39 GMT

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

Re: Connection issue with oracle DB

petter — Thu, 08 Oct 2015 13:41:11 GMT

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.

Re: Connection issue with oracle DB

avinashelite — Thu, 08 Oct 2015 13:43:06 GMT

Hi Mithun,

Check your TNS directory file once

Re: Connection issue with oracle DB

rteco0131 — Thu, 08 Oct 2015 14:14:01 GMT

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.

Re: Connection issue with oracle DB

petter — Thu, 08 Oct 2015 14:18:41 GMT

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.

Re: Connection issue with oracle DB

qlikviewwizard — Thu, 08 Oct 2015 14:32:43 GMT

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.

Re: Connection issue with oracle DB

Thu, 08 Oct 2015 14:36:18 GMT

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

Re: Connection issue with oracle DB

Tue, 13 Oct 2015 10:24:46 GMT

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

Re: Connection issue with oracle DB

qlikviewwizard — Tue, 13 Oct 2015 11:18:47 GMT

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

Re: Connection issue with oracle DB

rteco0131 — Tue, 13 Oct 2015 13:23:27 GMT

Data Source ODBC Test Connection ?

Re: Connection issue with oracle DB

Tue, 13 Oct 2015 14:52:00 GMT

This is how i'm trying to configure:

Re: Connection issue with oracle DB

rteco0131 — Tue, 13 Oct 2015 15:30:52 GMT

mithunck12

The problem isn't Qlikview.

TnsNames.ora: CONNECT_DATA = (SID = EMPRD.WORD) ?

Re: Connection issue with oracle DB

avinashelite — Wed, 14 Oct 2015 07:12:24 GMT

Hi Mithun,

Try to ping the sever from the command prompt and cross the check the TNS details again, if their is slight difference in the syntax or service name , it posse this error