Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

bibopipo
Contributor II

ora -12154 TNS prolem

Hi,

I'm trying to connect my Qlikview document with an oracle db, but it seems hard to do.

First of all, I create a new ODBC connection by the odbcad32.exe in windows\syswow64 and it works fine; the connection test is ok.

(I'm sorry, I forgot to mention that I've installed ORacle client 10.g and placed the TNSNAME.ora into the right folder (....\network\admin\)

When I open Qlikview and choose connect, I can see my odbc connection, but it doesn't work. It asks me user and password, but when I click OK I receive the message above: could not resolve the connect identifier specified.

HELP !! Please

Thanks in advance

1 Solution

Accepted Solutions
bibopipo
Contributor II

Re: ora -12154 TNS prolem

First of all thanks to everyone who spent his time to help me.

As first step, I removed and installed again the oracle client 11.

Secondly I configurated a new odbc connection and I found a bit odd thing:  choosing the "oracle client 11g" during the OBDC connection creation, the connection test is successful, but it doesn't work with qlik.

Choosing the "Microsoft ODBC" for oracle, qlikview works fine.

It is still a dark area for me, but it works

Thanks very much

6 Replies
MVP & Luminary
MVP & Luminary

Re: ora -12154 TNS prolem

Either tnsnames.ora is in the wrong place and can't be found, there's syntax error in tnsnames.ora or the database you're trying to connect with isn't defined in tnsnames.ora. See for example here for more information.


talk is cheap, supply exceeds demand
bibopipo
Contributor II

Re: ora -12154 TNS prolem

Hi Gysbert,

I'm a bit confused because the testing connection is successful using the odbcad32.exe tool.

What making me crazy is why the same connection doesn't work in Qlikview.

In short terms: the connection test by the odbcad32.exe panel is successful, so db name and tnsname.ora file should be correct;

connection tesintg by Qlikview is failed.

MVP & Luminary
MVP & Luminary

Re: ora -12154 TNS prolem

Did you tell Qlikview to specifically use the 32-bit driver? ODBC CONNECT32 TO....etc. Perhaps qlikview is trying a not properly configured 64-bit driver.


talk is cheap, supply exceeds demand
bibopipo
Contributor II

Re: ora -12154 TNS prolem

I tried in both modes: forcing 32bit and not, but the result it's always the same.

Concerning the driver I've installed 32bit driver: so I should have qlik and driver under the same structure

Highlighted
SunilChauhan
Esteemed Contributor

Re: ora -12154 TNS prolem

U need to provide TNS in your

apps->UserName->product -> 11.0.0( or something)->Client_1->network -> admin->tnsnames.ora

in this file enter you tns entry in below format

please enter enteries which in bold

TNSName=

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = Portno))

    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = Portno))

    (LOAD_BALANCE = ON)

    (FAILOVER = ON)

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = Service Name)

      (FAILOVER_MODE =

        (TYPE = SELECT)

        (METHOD = BASIC)

        (RETRIES = 20)

        (DELAY = 5)

      )

    )

  )

then try to run or

hope this helps

bibopipo
Contributor II

Re: ora -12154 TNS prolem

First of all thanks to everyone who spent his time to help me.

As first step, I removed and installed again the oracle client 11.

Secondly I configurated a new odbc connection and I found a bit odd thing:  choosing the "oracle client 11g" during the OBDC connection creation, the connection test is successful, but it doesn't work with qlik.

Choosing the "Microsoft ODBC" for oracle, qlikview works fine.

It is still a dark area for me, but it works

Thanks very much