Qlikview Oracle Connection

Tue, 02 Jul 2013 14:04:48 GMT

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

Re: Qlikview Oracle Connection

jagan — Tue, 02 Jul 2013 14:42:50 GMT

Hi,

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

Regards,

Jagan.