connect oracle

[Anonymous]

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.

[arsal_90]

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

[amit_saini]

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,

AS

[Anonymous]

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.

[arsal_90]

Please make sure you are checking Force 32 in QlikView Editor

[arsal_90]

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.

[arsal_90]

Hi Krishna

Is Your Problem is resolved

[vikasmahajan]

@arsal_90

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

If yes can you please share

Vikas

[arsal_90]

Hi @Vikas Mahajan

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

Muhammad Arsalan

[vikasmahajan]

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

Vikas