topic Re: Prompt credentials when reloading the data via ODBC connection in QlikView

Prompt credentials when reloading the data via ODBC connection

Wed, 04 Mar 2015 22:02:22 GMT

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 — Wed, 04 Mar 2015 22:42:27 GMT

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

sunilkumarqv — Thu, 05 Mar 2015 04:49:52 GMT

I think

in script settings

use Scramble Connect user Credentials option

Thu, 05 Mar 2015 13:25:50 GMT

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

Thu, 05 Mar 2015 13:26:36 GMT

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

Anonymous — Thu, 05 Mar 2015 13:28:52 GMT

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

ODBC CONNECT32 TO [DB_NAME;DBQ=DB_NAME]

Thu, 05 Mar 2015 14:07:16 GMT

Great, Thanks. that solves the purpose.