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
To: firebird-support@yahoogroups.com
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

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
>'pwd';
>* 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

library.

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

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

Are you sure you have the server running?

/hb




Yahoo! Groups Links

To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/