Maurice Ling wrote:

>Hi,
>
>I have a problem here that I hope someone can help. I need to use my
>Firebird database (remote) through SSH. How can I get connected to my
>remote database using isql.
>
>I've made a SSH tunnel using "ssh -L 3000:localhost:22 <remote host>".
>No log in is required because I've set it to using public key
>authentication. However, when I try to connect to the remote database
>using isql, I get the following:
>
>Maurice-Lings-Computer:~ mauriceling$ isql
>localhost:3000:/Users/mauriceling/MyProjects/Muscorian/BioDatabases/muscopedia.fdb
>-u mouse -p mouse
>Statement failed, SQLCODE = -902
>
>Unable to complete network request to host "3000".
>-Failed to establish a connection.
>-Operation timed out
>Use CONNECT or CREATE DATABASE to specify a database
>SQL>
>
>At the same time, I am creating a program using Python and kinterbasdb
>and is working nicely if both my program and the database is in the same
>machine, how can I get connected through SSH if I'm on different machines?
>
>Thanks a lot.
>
>Cheers
>Maurice
>
>
>

Hi, Maurice !

use "/" to specify the port number.

Maurice-Lings-Computer:~ mauriceling$ isql
localhost/3000:/Users/mauriceling/MyProjects/Muscorian/BioDatabases/muscopedia.fdb


see you !

--

Alexandre Benson Smith
Development
THOR Software e Comercial Ltda.
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br