3 Replies Latest reply: May 20, 2014 7:52 AM by pradeep t RSS

    Changing the database password

    Saad Tadili

      Hi,

       

      I created the following connection string using qlikview wizard :

       

      OLEDB CONNECT32 TO [Provider=MSDAORA.1;User ID=SOURCE;Data Source=XE] (XPassword is TKGJRaUGVJNKTaEGRBIB);



      I want to be able to change the database password (from a development environment to a production environment) without going through the wizard again and I don't want to delete the connection string and regenerate it.

       

      Is there a solution to this requirement with Qlikview or do I have every time to regenerate the connection.

       

       

      Thanks

        • Re: Changing the database password
          Massimo Grossi

          make 2 oledb connections (dev and prod)

          use a variable and an if statement to change from dev and prod

          you can further improve it adding an external file from which you read the variable; so when you change from dev to prod you only change the external file

          • Re: Changing the database password
            pradeep t


            Just create 2 connection strings one for Dev and other for Prod.

            Comment out the connection string, in  which region u are not working  on..

             

            EX: 

            Assume bellow is the  2 connection strings

            Connection_String_Dev

            Connection_String_Prod

             

            If u are working in Dev region, use the bellow format

            Connection_String_Dev

            // Connection_String_Prod

             

            If u are working in Prod region, use the bellow format

            //Connection_String_Dev

            Connection_String_Prod