3 Replies Latest reply: Mar 7, 2016 9:33 AM by Simon Brulotte RSS

    GetClearPassword function

    Simon Brulotte

      Hi,

      I have my connection string that goes as follows:

       

      LET STR_Connect = '[Provider=sqloledb;Data Source=$(SQLServerHostSecurite);Initial Catalog=$(SQLServerCatalogSecurite);User Id=$(SQLServerSecuriteUserId);Password=' & GetClearPassword('$(SQLServerSecuritePassword)', '$(CommonPath)') & ']';

      CONNECT To $(STR_Connect);

       

       

      Unfortunatly, the command line to retrieve the clear password does not execute, and Qlikview asks me for the clear password to connect to the DB.

       

      my VB script to determine the function is as follows:

       

      Function GetClearPassword(passw, currpath)

        strJava = """" & "java"" "

        strClassPath = " -cp " & """" & currpath & "\;"" "

         commandLineToExe=strJava & strClassPath & " HubizCryptoHelper -d " & passw

        

        Set objFileToWrite = CreateObject("Scripting.FileSystemObject").OpenTextFile("G:\Controle financier\SysFin\DEV_Qlikview\Finances GL\documents-tableaux-bord\logclear.txt",2,true)

      objFileToWrite.WriteLine(commandLineToExe)

      objFileToWrite.Close

      Set objFileToWrite = Nothing

       

        GetClearPassword= ExecuteShellProgram(commandLineToExe)

       

      End Function

       

      As you can see, I write to a log to make sure I have the proper CommandLineToEXE, and I do. Whatever outputs from there, I paste to cmd, and I get my clear password.

       

      But the function just does not execute itself like it used to, and I don't know what changed!!