Creation of configuration file for ODBC connection

[#1]

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.

[#2]

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