On 7/17/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hi, All: I am a new to perl. My perl code need to connect to the database in the remote server, and I can login that server via SSH. Can anyone give me a hint about how can I do that? Many thanks.
To answer accurately we need some more information first: 1. What brand of database is it: Informix, Oracle, DB2, PostgreSQL, MySQL, SQL Server, etc. (I assume it is an RDBMS rather than a flat file or hierarchal database)? 2. Does the database only accept local connections? (do you you really have to ssh to the box to connect to it?) 3. What OS is the client? 4. What OS is the server? 5. What control do you have over the remote machine? In most cases you can simply install the DBI module and a DBD module that corresponds to your RDBMS. If some reason you can only connect to the remote box through SSH you can still setup an ssh-tunnel and connect to the RDBMS with the DBI that way. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://learn.perl.org/