Can you recover the real xPassword from an OLE Database connection string?
Article Number: 000048552 | Last Modified: 2018/11/21
You have an OLE database connection in your script which shows "xPassword" with a scrambled password used by QlikView for your database connection, this is not the real password.
If you no longer know the database password, can you recover the real password from this?
QlikView 12.00, 12.10, 12.20 (November 2017) and up
xPassword shown in the script is scrambled and cannot be decrypted outside of QlikView.
No. It is not possible to recover the real database password from the scrambled "xPassword" password string shown in the QlikView script editor.
If you need to know the password, you would need to reset this on the database you're connecting to.