https://community.qlik.com/t5/Connectivity-Data-Prep/Qlikview-Database-connection/m-p/1802943#M8881 <P>Hi all,</P><P>We use a global variable file to store our SQL OLE DB connection information. This works well when the app is up and running, but if we need to go in and add/change a table we have to go through the process of creating a connection again in order to select the table we need.&nbsp;<BR /><BR />This doesn't sound a major issue but we have complex 16 character passwords to connect to the database, which we are not allowed to store in a text file (so no copy/paste).&nbsp;</P><P>Does anybody have any idea how we can trigger that connection when we need to go back into the script to add/change a table?<BR /><BR />Many thanks<BR />Mark&nbsp;</P> Tue, 27 Apr 2021 06:35:09 GMT csitqlik 2021-04-27T06:35:09Z https://community.qlik.com/t5/Connectivity-Data-Prep/Qlikview-Database-connection/m-p/1802943#M8881 <P>Hi all,</P><P>We use a global variable file to store our SQL OLE DB connection information. This works well when the app is up and running, but if we need to go in and add/change a table we have to go through the process of creating a connection again in order to select the table we need.&nbsp;<BR /><BR />This doesn't sound a major issue but we have complex 16 character passwords to connect to the database, which we are not allowed to store in a text file (so no copy/paste).&nbsp;</P><P>Does anybody have any idea how we can trigger that connection when we need to go back into the script to add/change a table?<BR /><BR />Many thanks<BR />Mark&nbsp;</P> Tue, 27 Apr 2021 06:35:09 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlikview-Database-connection/m-p/1802943#M8881 csitqlik 2021-04-27T06:35:09Z