Discussion Board for collaboration on QlikView Scripting.
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?
Hi, can you help me with this question please.
have you created connection string from start in mentioned qlikview application?
if not, please try to recreate connection string.
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.
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.
Ok I will do that. but I would like to know how appear the user and password into the string 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.