Hello,
if you already have specify username and password when launching isql
you don't need to specify it again during db creation.

If not try with:

CREATE DATABASE 'c:\databases\test.fdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 8192
DEFAULT CHARACTER SET ISO8859_1;

Regards
PAscal



--- In firebird-support@yahoogroups.com, "jeff_xky" <jeffelkins@...>
wrote:

>
> Howdy,
>
> I'm working my way through Borrie's Firebird Book, and have hit a
> weird roadblock with scripts. This script:
>
> SET SQL DIALECT 3;
> CREATE DATABASE 'c:\databases\test.fdb'
> PAGE_SIZE 8192
> DEFAULT CHARACTER SET ISO8859_1
> USER 'SYSDBA' PASSWORD 'masterkey';
>
> fails with:
>
> Dynamic SQL Error
> -SQL error code = -104
> -Token unknown - line 4, char 2
> -USER
> SQL>
>
> I've created the script with both notepad and vi (on a connected linux
> system) - it ends with several blank lines. I'd appreciate the loan of
> a clue :)
>
> Thanks,
>
> Jeff Elkins
>