connect to Firebird ??

Hi,

I've got Firebird installed on Linux. Now I want to connect to it via a tool like Putty.
my db is i the following dir: /opt/firebird/DigiLib.fdb

HOW DO I CONNECT TO IT ???

I want to test some stored procedures and just do some basic sql queries on it.

PLEASE HELP

many thanks

I'm using windows but try to connect to,

localhost:DigiLib.fdb

if it doesn't work you might need to create an alias for you database =)

or try

localhost:/opt/firebird/DigiLib.fdb

Thanks.

I want to connect via Putty through command line interface.

I then want to run things similar to mysql commands:
show tables,
select * form ...

o in other words: How can I see what tables is in my database ???

Putty is a terminal for SSH and Telnet (hope you are using SSH) so you'll need an SSH or Telnet server on the machine which is hosting Firebird, then you'll connect to that machine with Putty and you'll see the command prompt, from that one you'll execute isql and you'll connect to Firebird through it and issue all the sql commands there.

Thanks. Got that working.

Now, where can I find an example of all the commands (sql) I can use:


ex: what shouls I type in to show all the table in the current database ????

Look at my signature for a basic tutorial or surf around ibphoenix