-2

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.

Sir Rufo
  • 18,395
  • 2
  • 39
  • 73
andhika widi
  • 1
  • It might help to look through the source of [HeidiSQL](http://www.heidisql.com/). It is open source and can connect via plink. – David A Dec 08 '14 at 05:24
  • Wouldn't it be easier to use an ssh lib rather than an external process? Do you have any code? – David Heffernan Dec 08 '14 at 07:18
  • @DavidA, i tried heidiSQL but unfortunately couldn't find SSH Tunneling for Postgres. heidiSQL support SSH Tunneling for SQL, as i already tried. – andhika widi Dec 08 '14 at 08:46
  • @DavidHeffernan, i already searched free ssh library but not found yet so far. if you know one please advice. Thanks. – andhika widi Dec 08 '14 at 08:46

1 Answers1

0

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.

andhika widi
  • 1