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!

[rteco0131]

Data Source ODBC Test Connection ?

[#3]

This is how i'm trying to configure:

[rteco0131]

mithunck12

The problem isn't Qlikview.

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

[avinashelite]

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