Subject Re: [firebird-support] Re: Problems getting started with Firebird
Author Helen Borrie
At 06:54 AM 1/08/2005 +0000, you wrote:
>--- In, "labtech1652"
><labtechsupport@i...> wrote:
> > I am a new user of Firebird and am having trouble connecting with
> > example database, employee.fdb.
> >
> > I am currently trying Firebird in application mode, but get the same
> > problem in server mode. I am running Firebird on the same computer I
> > am trying to connect the database to. I get the following error;
> >
> > SQL> CONNECT "C:\Program Files\Firebird\Firebird_1_5
> > \examples\firebird.fdb"
> > CON> user 'SYSDBA' password 'masterkey';
> > Command error: CONNECT "C:\Program Files\Firebird\Firebird_1_5
> > \examples\firebird.fdb"
> > user:'SYSDBA'password'masterkey'
>I found the problem by searching the forum; the entries is double
>quotes need to be in single quotes e.g.
>SQL> CONNECT 'C:\Program Files\Firebird\Firebird_1_5
> > \examples\firebird.fdb'
>CON> user 'SYSDBA' password 'masterkey';
>Database:'C:\Program Files\Firebird\Firebird_1_5
> > \examples\firebird.fdb' user:sysdba
>It was confusing because the Quick Start Guide gives the procedure
>with the double quotes as shown.

Clarification :: Double or single quotes in isql (both work); double
quotes needed at the command line if you have spaces in the path
name; otherwise NO QUOTES in the command line.