Subject Re: [firebird-support] SQL ERROR -904 unnavailalble
Author Helen Borrie
At 02:14 PM 4/02/2004 -0300, you wrote:
>Good afternoon,
>
>Hi! I'm a Java/J2EE developer from Curitiba, Brazil and i'm facing a
>problem with Firebird. In fact, i have never used it before, but i'm
>trying to learn about it in the past two weeks. I have just installed
>the Firebird 1.5 (RC6) in my computer (Windows XP Professional) and i'm
>running Firebird as a service, but i'm trying to create a new database
>and facing a constant error (SQL ERROR -904 unnavailable database). I
>have read the instructions in 'Quick Start Guide' but i cannot do even
>the simpler instruction about using GSEC or ISQL because they always
>return to me same error: unnavailable database. I have searched on the
>Language Reference PDF and in the others PDF files in the doc package
>(60All.zip - ibphoenix.com) but i have not found anything that could be
>really helpful to me. Does anyone know how i can solve this problem? I'm
>losing a lot of time in it but the problem stills... i really don't know
>what to do...

"Unavailable database" usually means that the client can't find the named
database file in the place your connection string told it to look.

Initially, a connection has to find the security database
(security.fdb). If GSEC is returning "unavailable database" then something
is wrong with your installation - the server doesn't know the root
directory and cannot find the security database. You probably just
unzipped a "zip" file when you needed to use the ".exe" installer.

so......
Shut down the server.
Go into the command console and cd to Firebird's \bin directory.
Run the batch file install_super.bat (or install_classic.bat if it is
Classic that you installed).

Still, RC 6 is a very old beta (September 2003). Fb 1.5 is currently at RC
8. You really should download the RC8 installer (in a few hours, when
Sourceforge comes back on line) and start afresh.

/heLen


----------

instreg install -z
instsvc install -auto -superserver -g -z
instsvc start


[Non-text portions of this message have been removed]