Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
Create ODBC Data Source Connection for oracle in Windows - YouTube
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.
Hi Mithun,
Check your TNS directory file once
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.
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.
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.
Try checking the Force 32 Bit box before setting up the ODBC Connection. Your oracle server may not be 64 bit
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
Can you provide the screens of how you created the connection?