Firebird News

Monday, January 12, 2009

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

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> ;


No comments: