topic Re: Problem with the conection in QlikView

Problem with the conection

Thu, 06 Feb 2014 18:07:58 GMT

Hi,
I got a problem , when charge my model of QV in my machine ,it works, but when tried charge it in other machine,it didn't work,I use the OLE DB for ORACLE and, I have PL/oracle installed in my machine but not in the machine who failure ,so I think
that I need to install some driver or some thing like that?

the error that appear is :

error in the test conection with the provider ORA-12154 : TNS ...

some one can help me?

best regards.

Re: Problem with the conection

Gysbert_Wassenaar — Thu, 06 Feb 2014 18:13:03 GMT

This is not a Qlikview error. Something is wrong with your oracle setup. Perhaps you simply specified the wrong database name (sid). Google the ORA-12154 error and check if the possible causes are the problem on your machine.

Re: Problem with the conection

Anonymous — Thu, 06 Feb 2014 18:21:45 GMT

Roldan

Yup, as gwassenaar says it is an Oracle problem not a QlikView one.

Even though you have only given a bit of the Oracle error, it looks like a common error oftne caused by a problem in the tnsnames.ora file.

Maybe you could copy the tnsnames.ora from the good machine to the nad one.

Best Regards, Bill

Re: Problem with the conection

maxgro — Thu, 06 Feb 2014 20:31:40 GMT

Most Common Mistakes connecting to oracle

1) you don't have installed the oracle client; you can verify oracle client it in Windows start menu or running oracle sqlplus from command line: sqlplus username/password@connect_identifier

you can find the connect_identifier in your qlikview script, it should be similar to

OLEDB CONNECT32 TO [Provider=OraOLEDB.Oracle.1;Persist Security Info=True;User ID=username;Data Source=connect_identifier;Extended Properties=""] (XPassword is cryptedpassword);

2) 32/64 bit; is your oracle client 32 bit? use 32 bit oledb/odbc in qlikview; is your oracleclient 64 bit? ..........

the worst case is when you develop with the 32-bit oracle client on your machine and deploy on a qlikview server with 64 bit oracle client (so keep the connection in an include and change before the deploy)

3) oracle connection to the database is not configured, usually in tnsnames.ora (sometimes in sqlnet.ora)

search the file tnsnames.ora on your machine

open the tnsnames.ora and search the connect_identifier; copy few lines (the lines identify server, port and service_name of oracle database)

connect_identifier =

(DESCRIPTION =

(ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.32)(PORT = 1521)))

(CONNECT_DATA = (SERVICE_NAME = dev))

)

and add the lines (or replace if connect_identifier already exists) to tnsnames.ora on your server

To verify, as said above, open a command prompt and

sqlplus username/password@connect_identifier

connected

good luck

Re: Problem with the conection

Thu, 06 Feb 2014 20:39:01 GMT

If you've got ORA-12154 you have Oracle client installed.

Try this from cmd (replace <service_name> with actual name):

tnsping <service_name>

Re: Problem with the conection

Fri, 07 Feb 2014 16:57:05 GMT

well , the problem is the first choice, we don't have the sql plus , how can I install it

thanks a lot.

Re: Problem with the conection

maxgro — Fri, 07 Feb 2014 18:19:40 GMT

sqlplus.exe (and tnsping.exe too) is one of the programs installed with oracle client installation; you can use it to check the connection to the database

but

your problem is probably the third as Lukasz said (ORA-xxxxx messages come from the oracle client)

try again with sqlplus and/or tnsping from dos command prompt,

look for tnsnames.ora in .............\network\admin

Re: Problem with the conection

Fri, 07 Feb 2014 19:27:10 GMT

what it you mean with "service name"

because the client it is installed but , for example between other platforms, the communication is function very well with the BD.

Re: Problem with the conection

Fri, 07 Feb 2014 21:12:19 GMT

well, the other thing is that sql is not installed in the machine, only in mine so,

must work like that?

Re: Problem with the conection

Fri, 07 Feb 2014 21:52:01 GMT

Lukasz,

I tried to do that you said and in my machine, it work but not in other,I mean

tnsping is not recognised in other machine

do you have any idea?

best regards.

Re: Problem with the conection

Fri, 07 Feb 2014 22:05:19 GMT

I think I got it, SQLPlus is not installed ,I see in route and is not there.

thanks a lot.

Re: Problem with the conection

Tue, 11 Mar 2014 22:26:31 GMT

dear experts, the problem is finished when I just reinstall the ODAC, I think it, reload the data connection.

thanks lot.