Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Discussion Board for collaboration related to QlikView App Development.
I have a much easier solution to decrypt the XPASSWORD.
OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sql_user;Initial Catalog=DBSQL;Data Source=13.37.13.37;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=QLIKVIEW;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is XXXXXXXXXXXXXXXXXXXXXXX);
LET vPassword = REPLACE(CONNECTSTRING(), ';', '.');
TRACE $(vPassword);