I have a Progress Database whose username is 'Root' and it does not have any password.
For connecting QlikView to the database I am using ODBC connection. Connection String is getting generated I could select tables from the database as well to generate the script, but when I am reloading the document it is prompting for password which is not desirable.
ODBC CONNECT32 TO [PROGRESS PROD] (XUserId is XbACAZdNPDdeD);
Has anyone faced this kind of issue before? Please suggest if you have any opinion.