When we first put encyrption into the ASP Version of CranSoft (back at Cargill), Dan modified DataGarage so you could specify a Substitution Variable for the UserName and Password in the Connection string. This allowed us to keep the Connection string in clear text which makes is MUCH easier to debug and copy and change passwords.
Currently in CranSoft you have to enter the UserName and Password inline in the Connection String which exposes the Password. You also have to enter the Username and Password in those fields, creating redundant data.
Could we please work with Dan to re-enable the Substituion Variables? This would allow a connection string like below. Now I can leave my connection string un-encrypted and only manage my Password, which is hidden whether I choose to encrypt or not.