Subject RE: [firebird-support] Can't create database
Author Alan McDonald
> >> >>Hi,
> >> >>
> >> >>I have installed Firebird 1.5 on a windows 2003 server, and are
> >> following
> >> >>the Quick start Guide.
> >> >>when i follow the example on page 14 to create a new
> database i always
> >> >> get
> >> >>this error:
> >> >>SQL> create database 'f:\db\isa.fdb'
> >> >>CON> user 'sysdba' password 'masterkey';
> >> >>Statement failed, SQLCODE = -904
> >> >>
> >> >>unavailable database
> >> >>SQL>
> >> >>
> >> >>Can someone explain me wy i can't create a database ?
> >> >
> >> > Is drive F an actual drive or partition on the server? (Can't
> >> be a share,
> >> > mapped drive, or whatever....)
> >> I'ts a actual drive on the server
> >> >
> >> > Are you sure the server is running?
> >> yes i can see this in the services windows and the tool 'flamerobin'
> can connect to the security.fdb file and i can see all object in that
> database.
> >>
> >> Patrick
> >> >
> >
> > are you working on the server? can you use localhost:f:\db\isa.fdb?
>
> there is no file f:\db\isa.fdb, i think it should be created by the create
> database command yes ?
>
> Patrick
> >

If I stop my server and do the same thing I get
SQL> create database 'c:\data\isa.db' user 'sysdba' passwprd 'masterkey';
Statement failed, SQLCODE = -904

unavailable database
SQL>

look familiar?
Alan