Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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" )
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
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
BTW how can you see that the connection is succesful if the only test the ODBC driver provides (Test Connection) ... fails?
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)
)
)
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
Thanks Ashfaq, It worked