Update password of data connection

[fabionogarotto]

Hello all,

I created my first app, connected to a Microsft SQL server (test) via ODBC connector in Windows.

I want to install the app on another PC, connected to another Microsoft SQL server (production) via ODBC connector.

So I create an ODBC with the same name on the second PC, and connect it to the production server.

When I load data in the app on the second PC, of course it says that the credentials are not valid, but I cannot modify the ODBC connector in QlikSense because it is locked.

Solution is I unlock the data loader code, so I can delete the ODBC connector and load it again with the new password. But this way I loose the tables connection representation (the bubbles one).

Is it possible to just update the connection without unlocking the script?

Thank you very much,

Fabio

[hshabbir]

For posterity: You need to go to QMC to update the data connection.

https://help.qlik.com/en-US/sense-admin/November2024/Subsystems/DeployAdministerQSE/Content/Sense_De...

[Kaushik2020]

Try loading it via QMC as advised. To avoid such situations where you have a test and Production DB's better to write code using the load editor. Here loading data via load editor will help you to manage connections easily.