Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

amithmurali
Not applicable

Oracle 9i Database Connection Problem. ODBC Connection failed.

Hi guys,

I am having a problem in connecting to Oracle DB 9i.

when i create an ODBC connection, i can see that the connection is successful. but when i try to connect it in the QV i am getting the following error.


Connection Test Failed

SQL##f - SqlState: 08004, ErrorCode: 12154, ErrorMsg: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name

i am using QV desktop SR12.

DB is Oracle 9i 32bit.( i marked "force 32bit" )

1 Solution

Accepted Solutions
ashfaq_haseeb
Not applicable

Re: Oracle 9i Database Connection Problem. ODBC Connection failed.

Hi,

Can you try by downloading Qlik odbc connector launch recently by qlik.

That will enable you to connect with many such databases, Like PostgreSQL, MYSQL, Oracle, DB2 e.t.c without the need to install client.

Go to download page for the same.

Check below link

https://community.qlik.com/blogs/supportupdates/2015/06/30/connectivity-new-sfdc-and-odbc-connectors

Regards

ASHFAQ

5 Replies
Peter_Cammaert
Not applicable

Re: Oracle 9i Database Connection Problem. ODBC Connection failed.

This isn't a QlikView error, as it is happening in the ODBC driver.

Check some tips about solving this omnipresent Oracle problem here: ORA-12154: TNS tips

Peter

Peter_Cammaert
Not applicable

Re: Oracle 9i Database Connection Problem. ODBC Connection failed.

BTW how can you see that the connection is succesful if the only test the ODBC driver provides (Test Connection)  ... fails?

svenkita
Not applicable

Re: Oracle 9i Database Connection Problem. ODBC Connection failed.

Kindly check to see if the TNSNames.ora file is configured

Ensure the HOST, PORT & SID is configured properly

ORCL =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SID = orcl.star.cd)

    )

  )

ashfaq_haseeb
Not applicable

Re: Oracle 9i Database Connection Problem. ODBC Connection failed.

Hi,

Can you try by downloading Qlik odbc connector launch recently by qlik.

That will enable you to connect with many such databases, Like PostgreSQL, MYSQL, Oracle, DB2 e.t.c without the need to install client.

Go to download page for the same.

Check below link

https://community.qlik.com/blogs/supportupdates/2015/06/30/connectivity-new-sfdc-and-odbc-connectors

Regards

ASHFAQ

amithmurali
Not applicable

Re: Oracle 9i Database Connection Problem. ODBC Connection failed.

Thanks Ashfaq, It worked