How to write a command in plink using delphi 7

Question

Need to be guided. I wanna make an application that can connect to postgre database through ssh server. My idea is to make a connection using plink => login to ssh2 server => login to database postgre => do some query (select ... from...) => get the result => show the result in table.

I get dificulties to build connection using plink since we need to write a username, password, etc. in interactive mode. I have no idea to do it by using Delphi 7, especially to pass a string (for example password) to existing plink.

Any better or easier advice are welcome.

Answer 1

Thanks Team for all great support, especially @DavidHeffernan for the advice (use ssh library).

Finally, i tried chilkat ssh library to connect to my ADO Connection. Problem solved.