Subject Re: [firebird-support] Isql and connect to database...
Author Helen Borrie
At 01:16 PM 27/01/2004 +0100, you wrote:
>Hi, I usually use Database Workbench when working with firebird, but I'm
>trying to connect to my database using isql. Either I get a "command
>error" or "uanavailable database" so maybe my syntax is wrong...?
>SQL> CONNECT "c:\firebird\database one\test.fdb" USER 'sys' PASSWORD
>* returns: Statement failed, SQLCODE = -904, unavailable database

Yes to the double quotes for the path, because of the space in the pathname.
No to the quotes on the user name and password. (but they do need the
single quotes for the isql command-line syntax).

If you still get the problem then isql might be finding the wrong client

>SQL> CONNECT c:\firebird\database one\test.fdb USER 'sys' PASSWORD
>* returns: Command error: ...

Of course. It is interpreting "one" as a command, because of the space.

Are you sure you have the server running?