2 Replies Latest reply: Dec 2, 2016 1:45 AM by Kerk Ying Ng RSS

    Automate updating of ODBC connection password

    Kerk Ying Ng

      Hi all,

       

      We have an ODBC source that is required by policy to change its password every 3 months. With 20+ QVWs connection to this data source, we are trying to find a way to update the passwords in an efficient manner instead of accessing the thick client and changing the password manually for all the QVWs.

       

      Does anybody here have any experience with possibly externalizing and automating this process of updating the password? We know it can be done through interface to connect to a data source, but can the password be updated anywhere else (i.e through QMC etc?)

       

      Thanks a million!