topic Re: Reading dyanamic password in QlikView https://community.qlik.com/t5/QlikView/Reading-dyanamic-password/m-p/770209#M1051262 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P>Temp:</P><P>LOAD @1:n as MyPassword FROM <EM>...passwordfilehere...;</EM></P><P></P><P>LET vPassword = peek('MyPassword');</P><P></P><P>DROP TABLE Temp;</P><P></P><P>CONNECT TO [Provider=<EM>...driver_here...</EM>;Persist Security Info=False;User ID=<EM>...username_here...</EM>;Password=<EM>$(vPassword)</EM>;Data Source=<EM>...db_name_here...</EM>];</P></BODY></HTML> Wed, 05 Nov 2014 11:03:21 GMT Gysbert_Wassenaar 2014-11-05T11:03:21Z Reading dyanamic password https://community.qlik.com/t5/QlikView/Reading-dyanamic-password/m-p/770208#M1051261 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I want to read password from a file in the system to connect to the database.</P><P>Is it possible &amp; how??</P><P></P><P>Thanking in advance</P><P>Keshav</P></BODY></HTML> Wed, 05 Nov 2014 08:44:46 GMT https://community.qlik.com/t5/QlikView/Reading-dyanamic-password/m-p/770208#M1051261 2014-11-05T08:44:46Z Re: Reading dyanamic password https://community.qlik.com/t5/QlikView/Reading-dyanamic-password/m-p/770209#M1051262 <HTML><HEAD></HEAD><BODY><P>Something like this:</P><P></P><P>Temp:</P><P>LOAD @1:n as MyPassword FROM <EM>...passwordfilehere...;</EM></P><P></P><P>LET vPassword = peek('MyPassword');</P><P></P><P>DROP TABLE Temp;</P><P></P><P>CONNECT TO [Provider=<EM>...driver_here...</EM>;Persist Security Info=False;User ID=<EM>...username_here...</EM>;Password=<EM>$(vPassword)</EM>;Data Source=<EM>...db_name_here...</EM>];</P></BODY></HTML> Wed, 05 Nov 2014 11:03:21 GMT https://community.qlik.com/t5/QlikView/Reading-dyanamic-password/m-p/770209#M1051262 Gysbert_Wassenaar 2014-11-05T11:03:21Z