topic Re: How can I decode a pair of XUserID and XPassword in ODBC Connector? in QlikView

How can I decode a pair of XUserID and XPassword in ODBC Connector?

thomas_wang — Tue, 14 Aug 2018 08:20:08 GMT

Hi All,

I have read the topic "How to generate xuser & xpassword in txt file".

but the VBScript provided from the answer cannot be run and report syntax errors in my QlikView,

Any other ideas?

Thanks!

Re: How can I decode a pair of XUserID and XPassword in ODBC Connector?

thomas_wang — Tue, 14 Aug 2018 08:33:20 GMT

In the VBScript, I deleted the underline and merged the context into the same line. No syntax errors were reported again, but the result of conversion was garbled.

Re: How can I decode a pair of XUserID and XPassword in ODBC Connector?

thomas_wang — Wed, 15 Aug 2018 01:09:15 GMT

Here I found my own way:

1. Rename the connection string that you have defined before.

2. Reload.

3. Then you will receive an error "SQL##f - SqlState: 28000, ErrorCode: 18456, ErrorMsg: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'XXX'." Note that the last XXX is the original username.

4. Modify the connection parameters again to copy the XPassword to the XUserID.

5. Reload again.

6. Then you will receive an similar error. Note that this time the last XXX is the original password.

Re: How can I decode a pair of XUserID and XPassword in ODBC Connector?

vhayward — Tue, 18 Sep 2018 09:09:03 GMT

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);

Re: How can I decode a pair of XUserID and XPassword in ODBC Connector?

thomas_wang — Wed, 19 Sep 2018 02:02:43 GMT

If the connection string works, the CONNECTSTRING() function returns detailed connection information including the plaintext username and password.

Replace(ConnectString(), ';', '\n')

Re: How can I decode a pair of XUserID and XPassword in ODBC Connector?

rzenere_avvale — Wed, 04 Sep 2019 12:50:03 GMT

Great solution, I didn't know that function.

Many thanks!
Riccardo

Re: How can I decode a pair of XUserID and XPassword in ODBC Connector?

cg1_qlik — Tue, 07 Apr 2020 11:44:00 GMT

It works thank you

Regards

Malli

Re: How can I decode a pair of XUserID and XPassword in ODBC Connector?

tester — Tue, 13 Oct 2020 15:17:16 GMT

is this not working anymore in QV 12.50 ?