topic Re: connect oracle in QlikView

connect oracle

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hi all.

i am using 64 bit OS, i am unable to connect oracle( i tried force 32 bit). Pls healp me.

ERROR: SQL##f - SqlState: 08004, ErrorCode: 12154, ErrorMsg: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified

Regards,

Krishna.

Re: connect oracle

arsal_90 — Wed, 19 Nov 2014 05:27:10 GMT

Hi you have to work first on TNS.ora file where you have to pass credentials and connectivity. Make sure that your tns.ora file must be right

Re: connect oracle

amit_saini — Wed, 19 Nov 2014 05:35:58 GMT

Krishna,

Please check your tnsnames.org file , you need to define few credentials for your connection first like below:

Test=

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = Your_Host_name)(PORT = Port_number))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = Service_name)

)

Thanks,

Re: connect oracle

Anonymous — Wed, 19 Nov 2014 05:48:57 GMT

Hi Muhammad

i never find oracle ODBC driver in 64 bit OS. But I created ODBC connection C:\Windows\SysWOW64\odbcad32.exe.

in Odbc test connection :successful.

in qlikview when i click on test connection i got this error message.

ERROR: SQL##f - SqlState: 08004, ErrorCode: 12154, ErrorMsg: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified

Regards,

Krishna.

Re: connect oracle

arsal_90 — Wed, 19 Nov 2014 05:52:56 GMT

Please make sure you are checking Force 32 in QlikView Editor

Re: connect oracle

arsal_90 — Wed, 19 Nov 2014 05:55:41 GMT

Go to QlikView Editor by pressing Ctrl E and then select ODBC and make sure there is Force 32 Check box you have to press Check on that.

Re: connect oracle

arsal_90 — Wed, 19 Nov 2014 06:43:04 GMT

Hi Krishna

Is Your Problem is resolved

Re: connect oracle

vikasmahajan — Wed, 19 Nov 2014 07:07:33 GMT

@arsal_90

you have script sample how to get oracle data into Qlikview ?

If yes can you please share

Vikas

Re: connect oracle

arsal_90 — Wed, 19 Nov 2014 08:37:49 GMT

Hi @Vikas Mahajan

What type of script sample you required? You required connection string or Tables Scripting

Muhammad Arsalan

Re: connect oracle

vikasmahajan — Thu, 20 Nov 2014 03:36:04 GMT

Thanks I want Tables Scripting Samples for Oracle can you provide the same.

Vikas