topic Re: How to indicate the password to access a DB in the script ? in QlikView https://community.qlik.com/t5/QlikView/How-to-indicate-the-password-to-access-a-DB-in-the-script/m-p/642488#M677193 <HTML><HEAD></HEAD><BODY><P>Hi Laura,</P><P></P><P>when you declare your database thru ODBC , --&gt; configure , give password and login</P><P>When you do your connection in QV with the wizard, it normally writes</P><P>ODBC CONNECT TO [OPTDEC;DBQ=OPTDEC]&nbsp; with login=blablabla, pasword=pwd</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Fri, 06 Jun 2014 09:41:48 GMT 2014-06-06T09:41:48Z How to indicate the password to access a DB in the script ? https://community.qlik.com/t5/QlikView/How-to-indicate-the-password-to-access-a-DB-in-the-script/m-p/642487#M677192 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>To connect to a Oracle database, i have to enter a password in a pop-up.</P><P></P><P>The problem is each time I refresh the application, the pop up opens up and I have to manually enter the password... So I have to be in front of my computer if I want to refresh this app...</P><P></P><P>Is there a way to "write" the password in the script so I can plan the refresh ?</P><P></P><P>Here is the code I currently have to connect to my DB :</P><P></P><P>ODBC CONNECT TO [OPTDEC;DBQ=OPTDEC];</P><P></P><P>OPTDEC is the name of the database.</P><P></P><P>Thank you for your help.</P><P></P><P>Have a good day <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Laura</P></BODY></HTML> Fri, 06 Jun 2014 09:34:59 GMT https://community.qlik.com/t5/QlikView/How-to-indicate-the-password-to-access-a-DB-in-the-script/m-p/642487#M677192 2014-06-06T09:34:59Z Re: How to indicate the password to access a DB in the script ? https://community.qlik.com/t5/QlikView/How-to-indicate-the-password-to-access-a-DB-in-the-script/m-p/642488#M677193 <HTML><HEAD></HEAD><BODY><P>Hi Laura,</P><P></P><P>when you declare your database thru ODBC , --&gt; configure , give password and login</P><P>When you do your connection in QV with the wizard, it normally writes</P><P>ODBC CONNECT TO [OPTDEC;DBQ=OPTDEC]&nbsp; with login=blablabla, pasword=pwd</P><P></P><P>best regards</P><P>Chris</P></BODY></HTML> Fri, 06 Jun 2014 09:41:48 GMT https://community.qlik.com/t5/QlikView/How-to-indicate-the-password-to-access-a-DB-in-the-script/m-p/642488#M677193 2014-06-06T09:41:48Z