Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

krishna4bo
Contributor

connect oracle

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.

Tags (2)
9 Replies
arsal_90
Contributor III

Re: connect oracle

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
Honored Contributor III

Re: connect oracle

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

krishna4bo
Contributor

Re: connect oracle

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
Contributor III

Re: connect oracle

Please make sure you are checking Force 32 in QlikView Editor

arsal_90
Contributor III

Re: connect oracle

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
Contributor III

Re: connect oracle

Hi Krishna

Is Your Problem is resolved

vikasmahajan
Honored Contributor III

Re: connect oracle

@

If yes can you please share

Vikas

arsal_90
Contributor III

Re: connect oracle

Hi @Vikas Mahajan

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

Muhammad Arsalan

vikasmahajan
Honored Contributor III

Re: connect oracle

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

Vikas