Qlikview Oracle Connection

[#1]

Hi All,

I am trying to connect qlikview(on my home desktop)   to oracle database(at clients location) 

I have installed Oracle instant client basic  and instant client ODBC

and created system variable(TNS_ADMIN) on my computer with variable value as C:\Oracle\instantclient_11_2\Network\Admin

and  i have defined tnsnames.ora file  as following 

TNS_ADMIN=

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 1.1.1.1)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SERVICE_NAME = MX6LFP )

    )

  )

I have changed the host address in the script i pasted here for security reasons 

and when i try to create a ODBC connection i get following error .  Apprecite any help on this

Thanks

[jagan · Accepted solution]

Hi,

The error message says "Connection Timeout occurred", usually this error occurs if you do not have access to the system.   

Regards,

Jagan.