Subject RE: [firebird-support] Isql and connect to database...
Author Henrik Sitter
Hi, Helen you're an angel!

I'm much embarrassed.... for some reason the server was down...

Better check properly next time.

Thx, Henrik

-----Original Message-----
From: Helen Borrie [mailto:helebor@...]
Sent: 27. januar 2004 13:32
Subject: Re: [firebird-support] Isql and connect to database...

At 01:16 PM 27/01/2004 +0100, you wrote:
>Hi, I usually use Database Workbench when working with firebird, but
>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
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?


Yahoo! Groups Links

To visit your group on the web, go to:

To unsubscribe from this group, send an email to:

Your use of Yahoo! Groups is subject to: