Prompt just for password in the SQL OLE DB Connection?

[#1]

Hello QV community,

Question on the OLEDB connection prompt when connecting to a SQL database:  Is there a way to prompt just for the password on the OLEDB Connection prompt?  With the following statement in the Load script, every time the data reload is done, the user has to type in all the credential details such as server name, username, password etc:

CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True]; 

I'm interested to know if there is a way for the QlikView file to save the last used servername and username in the dialog, but just prompt for the password. 

Don't want to use the <include> statement/text file to store the passwords as there are security pitfalls with it, nor can we use the input box feature in QV to get user input, but then the password will not be masked.  So any suggestions to mask or prompt the password?

Thanks in advance!

[maxgro · Accepted solution]

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=sisim_stat;Data Source=10.0.00.001;];

[#3]

Thanks Massimo - that works great!

[#4]

Hi Massimo and QV community, quick follow-up question.  The above OLEDB CONNECT TO statement works great if its in a separate include file or in the load script as-is.  However if I build this connection string in a variable (see example below) and then use the variable in the OLEDB CONNECT statement, it does not work as its supposed to.  Any suggestions to use variables in it?

ConnStr = "[Provider=SQLOLEDB.1;Persist Security Info=False;User ID='$([SQLUserID])';Initial Catalog='$([SQLDB])';Data Source='$([SQLServer])']";
OLEDB CONNECT32 TO $(ConnStr);

Thanks in advance!!