creating an db with isql-fb in firebird classic

If you try to create an db from isql-fb utility and you use firebird classic

then you might need to add the host in the connection string

$ isql-fb -user SYSDBA -password masterkey

Use CONNECT or CREATE DATABASE to specify a database

SQL> create database "/var/lib/firebird/2.1/data/fooozz.fdb"

CON> ;

Statement failed, SQLCODE = -902

cannot attach to password database

SQL>

Here is the correct way to create the database with classic

$ isql-fb -user SYSDBA -password masterkey

SQL> create database "localhost:/var/lib/firebird/2.1/data/fooozz.fdb"

CON> ;

.:(firebird):..:(databases):..:(sql):.