Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have connected to my database using ODBC connection.
ODBC CONNECT TO dummy (XUserId is KFSXUQRMFDeCWaNOFTceH, XPassword is TALZXQRMFDeCGfA);
how do i create a configuration file and assign it to a variable in the qvw file?
Also how do i overcome the encrypted username and password in the configuration.txt file.
Please help.
Its urgent.
Thanks in advance.
Hi,
you can copy a part of your script in a txt file (let's call it connection.txt),
then in your script, you can use
$(Include=connection.txt);
to call it
You can use it several times in a Script if need.
please note you can still use all QlikView Script functions in the txt, for example you can use SWITCH computername() to use a different ODBC connection depending on the current computer
for the encryption, personnally when I change my password, I create the ODBC In QlikView file then I copy / paste the line in my connection.txt 🙂 maybe it's work if you not encrypt your password but I'm not sure at all ??
hope it helps
Best regards