Prompt credentials when reloading the data via ODBC connection

[#1]

We have multiple users accessing the same document and reloading the data.

In order to reload the data , each user needs to change the connection string in the scrip editor,

So is there a way we can have a prompt asking for credentials each time Qlikview tries to connect to the Database

current connection string:

ODBC CONNECT32 TO [DB_NAME;DBQ=DB_NAME] (XUserId is IONEQSVGYKDFTYAHHE, XPassword is POidYGvERTbATYQb);

Thank you.

[Anonymous]

Recreate the Connect String, but when doing so untick Save Password.

[sunilkumarqv]

I think

in script settings

use Scramble Connect user Credentials option

[#4]

I do have Scramble Connect User Credentials already ticked but that doesnt seem to help.

[#5]

Can you please point me to the settings where I can untick Save Password?

[Anonymous]

Try to remove credentials from the CONNECT statement, keep this:

ODBC CONNECT32 TO [DB_NAME;DBQ=DB_NAME]

[#7 · Accepted solution]

Great, Thanks. that solves the purpose.