Token unknown in -104 SQLCODE

Question

CREATE DATABASE test.fdb -user SYSDBA -password *******;

I use the command above to create a database for my project on Windows 7. I am new to Firebird SQL, I used my login credentials, but it shows some error. So how can I reset my password?

SQL error code = -104
Token unknown. 

I do not even know the value of SQLCODE = -104 .

Answer 1

The error shown is not caused by ignorance of the database password; you have a syntax error in the instruction CREATE DATABASE. An unknown token means that the parser is reading what he did not expect; the error is usually followed by an offensive token.

ISQL Firebird 3.0, :

SQL> CREATE DATABASE test.fdb -user SYSDBA -password *******;
Statement failed, SQLSTATE = 42000
SQL error code = -104
-Token unknown
-test

, ( ) test - .

CREATE DATABASE:

 CREATE {DATABASE | SCHEMA} '<filespec>'
 [USER 'username' [PASSWORD 'password']]
 [PAGE_SIZE [=] size]
 [LENGTH [=] num [PAGE[S]]
 [SET NAMES 'charset'] 
 [DEFAULT CHARACTER SET default_charset
   [COLLATION collation]] -- not supported in ESQL
 [<sec_file> [<sec_file> ...]]
 [DIFFERENCE FILE 'diff_file']; -- not supported in ESQL

 <filespec> ::= [<server_spec>]{filepath | db_alias}

 <server_spec> ::= servername [/{port|service}]: | \\servername\

 <sec_file> ::= FILE 'filepath'
 [LENGTH [=] num [PAGE[S]] [STARTING [AT [PAGE]] pagenum]

, :

create database 'test.fdb' user SYSDBA password '*******';

:

• ( )
• - user password
• ( , )

, SQL error code ( ).