Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
pgalvezt
Valued Contributor

Oracle Connection

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.

6 Replies
pgalvezt
Valued Contributor

Re: Oracle Connection

Hi, can you help me with this question please.

Thanks.

Not applicable

Re: Oracle Connection

hello,

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

if not, please try to recreate connection string.

lp,

Tajana

pgalvezt
Valued Contributor

Re: Oracle Connection

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.

christian77
Valued Contributor

Re: Oracle Connection

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.

pgalvezt
Valued Contributor

Re: Oracle Connection

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

Thank you.

christian77
Valued Contributor

Re: Oracle Connection

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.

Community Browser