Invoking an external program that requires a password
There are many instances of external programs that will require a password to be used. For instance, you may be required to establish a VPN connection before you can even connect to your databases.
The example we will use here, because it is easier to demonstrate, will be to decrypt an encrypted file using an external program.
Getting ready
The external program that we will use to build in this recipe is AES Encrypt, an open source encryption application that can be downloaded at http://www.aescrypt.com/download.html. After downloading the console version of the program for your operating system, unzip the executable and put it in a folder next to the file that you will want to encrypt and decrypt. The steps of this recipe assume that we have copied the executable in the c:\temp
directory. If you are using another operating system or if you decide to put the program in a different folder, you will have to adapt the instructions of this...