Please give me solution for Qlikview-Oracle connection errors

[#1]

Hi,

I can able to connect oracle itself through connection type:TNS and connection type:Basic. But I am unable to connect oracle from Qlikview. I am getting attached errors.  Could anyone please give me solution for this error messages.

[bindu_apte]

Hi,

Check whether driver is been installed or not.

[gregortvw]

Hi,

try to enter this to you cmd:

tnsping FDWHUND

If you receive an error like:"tnsping could not be recognized ...", there is an error with your Oracle driver.

If you receive sth like "could not be resolved", you have a problem with your DNS server (or server name is wrong)

Regards,

Gregor

[#4]

when I clicked on connect button in qlikview script editor, I am able to see all drivers in the data link properties window. could you pls tell me how to check wether driver is installed properly or not?

[#5]

thank you, no error came when I typed in cmd prompt

[prasadcm]

Hi,

It seems that you have to make changes in tnsnames.ora file

1)Verify that the tnsnames.ora file has the alias and the service name,

TNS entry for the Oracle database

===========================

OracleDB_Dev =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = server01.mydomain.com)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = OracleDB)

      (SERVER = DEDICATED)

    )

  )

tnsnames.ora file  can be found in Dir:\app\product\11.1.0\client_1\network\admin

For example my path was 'C:\app\shilpa.naik\product\11.2.0\client_1\network\admin\sample'

PFA notepad

[Ronnie_Taborn]

This might help you.  Oracle error ora-12154: TNS:could not resolve the connect identifier specified