Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

encryption/hashing of clear text password for SQL Server?

I need help with encryption/hashing of clear text password for SQL Server, without manually creating through connect string through the "Data Link Properties" dialog.

e.g. replace

OLEDB CONNECT TO [Provider=SQLOLEDB;User ID=sa;Initial Catalog=Demo;Data Source=CTX39] (Password is pass);

with

OLEDB CONNECT TO [Provider=SQLOLEDB;User ID=sa;Initial Catalog=Demo;Data Source=CTX39] (XPassword is AIceIYFMTbcOL);

How can I get "AIceIYFMTbcOL" for "pass" without going through the creation of connection string in QV & then copying it to configuration file process; for each User ID/Initial Catalog/Data Source/Password combination.

Thanks,

Prashant

1 Reply
bumin
Contributor II

Re: encryption/hashing of clear text password for SQL Server?

Hi Prashant,

the connect stringt with password is like follows

Provider=SQLOLEDB.1;Password=yourpassword;Persist Security Info=True;User ID=sa;Initial Catalog=coda;Data Source=localhost;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SRVQV;Use Encryption for Data=False;Tag with column collation when possible=False

regards

Bumin

Community Browser