topic Re: Oracle Connection in QlikView

Oracle Connection

pgalvezt — Fri, 22 Jun 2012 19:56:10 GMT

Hi, I'm been checking a oracle connection and tried of emule it. But why in the connection appears this:

ODBC CONNECT TO [SIG-SCF_DESARROLLO;DBQ=GESDES ] (XUserId is JQFeTaNOVbXEXSFMETNB, XPassword is aHXbVaNOVbXEXSFMEbCB);

But when do my connection just appear this:

ODBC CONNECT TO [SIG-SCF_DESARROLLO;DBQ=GESDES ]

The system show me the tables but in the realod moment the connection fail. Why appear the user and pass if I put the user and pass in the ODBC connexion?

Thanks.

Re: Oracle Connection

pgalvezt — Mon, 25 Jun 2012 16:00:22 GMT

Hi, can you help me with this question please.

Thanks.

Re: Oracle Connection

Tue, 26 Jun 2012 10:27:21 GMT

hello,

have you created connection string from start in mentioned qlikview application?

if not, please try to recreate connection string.

lp,

Tajana

Re: Oracle Connection

pgalvezt — Tue, 26 Jun 2012 14:33:05 GMT

Hi, Yes I have created the connection. Qlikview shows me the tables but when I do double clic no matter what table. The connection fail. But if I copy the (XUserId is JQFeTaNOVbXEXSFMETNB, XPassword is aHXbVaNOVbXEXSFMEbCB);

The connection works perfectly.

Re: Oracle Connection

christian77 — Tue, 26 Jun 2012 15:21:19 GMT

That happened to me before.

You must know the names of the tables and do it blind.

First bring the whole table (load * from table) and then specify the fiels in a second step.

And yes, the connection works fine.

luck.

Re: Oracle Connection

pgalvezt — Tue, 26 Jun 2012 15:37:29 GMT

Ok I will do that. but I would like to know how appear the user and password into the string connection.

Thank you.

Re: Oracle Connection

christian77 — Tue, 26 Jun 2012 15:43:18 GMT

It's better not to show them.

Usually if is an ODBC it will show them encripted. If is an OLEDB it probable shows them.

You can use the hiden script as well.

luck.