One menu for 3 servers

[Rudi Martin]

Hi everyone. I need to create a menu that spans over 3 servers. On our 3 servers we have a database on each that the users connect to via a menu per server.

I need to create one single menu that calls all 3 databases as needed.

Where do I start ? How do I connect to another server's database via the menu ? Where do I store the main menu etc. ?

Please share all your knowledge regarding this please.

Thanks

Rudi

[Shannon Petry]

Since a menu can be anything from VT-100, to X-Motiff, to Pizza Hut, you need to be more specific about what the Menu actually is.

If you dont know what the Menu is, stick with Pizza Hut.

Regards,
Shannon

[Chris Vail]

We need more information: what exactly are you trying to do? Are you trying to balance users between 3 servers?


Chris

[Shannon Petry]

Not just what you are trying to do, but methods that you are familiar with, and the database.

If you can not do C/C++ programming, I would not recommend you compile your own X window's app to handle this.

Apache+CGI may be able to do this, but again if you cant write perl, what is the point in telling you to use it.

Noone is going to say use Perl::mysql if your using SAP.

Regards,
Shannon

[Rudi Martin]

Hi there to you both who replied. Ok , to simplify things , I'm pasting the menu script on here so you can see. At the moment there's three options to choose from , all three linking to databases on the same server. I need to change it to have other options as well , to databases on different servers. Does that sound better ?

[Massimo Bianchi]

Hi,
from the doc toy attache the answer is quite simple: use the command "remsh"

For a complete reference use "man remsh", btu for a quick one:


remsh HOST -l USER -n COMMAND



Using this sintax you will be able to start program on the remote server, provided toy set up correctly permission for the remsh to work.


There are some limitation in what remsh can do, for example in the redirection to files and so on.

Another point of consideration is if your user will use character terminal or window-capable terminal.

In the second chance you may think of starting a remote xterm that start your menu.


HTH,
Massimo

[Leif Halvarsson_2]

Hi,
Is this a Progress database ?

With an Oracle database (for example) this should be rather easy using SQLnet. With this you can connect from any client to any database server just modifying the connect string. Sure there is similar functionality in Progress but, without knowing anuthing about Progress, it is not possible to give details.