Problem with using IS_SQLSERVER_PASSWORD within script

[Peter44523]

I am trying the dynamically update a database connection within a web.config file. But when I try to use the property IS_SQLSERVER_PASSWORD, the property only returns the first letter of the password.

[hidenori]

How do you retrieve the value of the IS_SQLSERVER_PASSWORD property? I just tested with the MsiGetProperty function in an InstallScript custom action, and I was able to get the whole string stored in the property.

function MyFunction(hMSI)   
    // To Do:  Declare local variables.
string szValue;
number nValue;
begin             

    // To Do:  Write script that will be executed when MyFunction is called.
 nValue = 250;
 MsiGetProperty(ISMSI_HANDLE, "IS_SQLSERVER_PASSWORD", szValue, nValue);
 MessageBox( szValue, MB_OK );
end;