topic Re: Prompt just for password in the SQL OLE DB Connection? in QlikView

Prompt just for password in the SQL OLE DB Connection?

Thu, 29 May 2014 16:03:07 GMT

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!

Re: Prompt just for password in the SQL OLE DB Connection?

maxgro — Thu, 29 May 2014 16:07:50 GMT

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

Re: Prompt just for password in the SQL OLE DB Connection?

Thu, 29 May 2014 16:54:46 GMT

Thanks Massimo - that works great!

Re: Prompt just for password in the SQL OLE DB Connection?

Fri, 06 Jun 2014 19:26:37 GMT

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!!