topic Please give me solution for Qlikview-Oracle connection errors in QlikView

Please give me solution for Qlikview-Oracle connection errors

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Please give me solution for Qlikview-Oracle connection errors

bindu_apte — Mon, 11 Jul 2016 09:18:02 GMT

Hi,

Check whether driver is been installed or not.

Re: Please give me solution for Qlikview-Oracle connection errors

gregortvw — Mon, 11 Jul 2016 09:46:09 GMT

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

Re: Please give me solution for Qlikview-Oracle connection errors

Mon, 11 Jul 2016 09:51:41 GMT

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?

Re: Please give me solution for Qlikview-Oracle connection errors

Mon, 11 Jul 2016 10:06:46 GMT

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

Re: Please give me solution for Qlikview-Oracle connection errors

prasadcm — Mon, 11 Jul 2016 10:35:15 GMT

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

Re: Please give me solution for Qlikview-Oracle connection errors

Ronnie_Taborn — Mon, 11 Jul 2016 12:04:00 GMT

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