--- In firebird-support@yahoogroups.com, "David Cornelius" <dev@c...>
wrote:

> Geppo wrote:
> > Hy to all,
> > I can't connect to Employee.fdb, or create a new database, getting
> > the error: Statement failed, SQLCODE = -904
> >
> > That's what i've done:
> > OS: Windows XP-PRO.
> > - Install Firebird-1.5.0.4306-Win32.exe (several times and

options)

> > - Install Marathon_1.5.0_Rel.zip
> >
> > The Guardian says that Firebird server has been started,
> > (...)\bin\isql.exe works, giving me the SQL prompt, but there are

no

> > wat to connect to any database.
>
> Assuming you installed to the default drive C: and assuming there

was no

> previous installation of Firebird or InterBase (leaving behind

gds32.dll in

> the windows\system32 directory), try this:
>
> C:> ISQL -u sysdba -password masterkey
>
> SQL> CONNECT
> servername:c:/progra~1/firebird/firebird_1_5/examples/employee.fdb;
>
>
> "servername" should be replaced with either "localhost" or the name

of your

> server, of course. After sucessful connect, you should get a line

that starts

> with "Database: " and lists the database you just connected to

along with the

> username connected with.
>
>
> --
> David Cornelius
> CorneliusConcepts.com

having the same problem.
Installed the standard version on an MS-XP-Pro Box.
First Firebird installation on this Box.

Services are running:
C:\>net start
...
Firebird Guardian - DefaultInstance
Firebird Server - DefaultInstance
....

none of the hints the guides I found works.
Here the things i tried:

*) tried to change sysdba password:
C:\WORK\FIREBIRD1\bin>gsec -user sysdba -password masterkey
unavailable database
unable to open database

*) local connect to sample db
C:\WORK\FIREBIRD1\bin>isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> CONNECT "C:\WORK\FIREBIRD1\examples\EMPLOYEE.FDB" user 'SYSDBA'
password 'masterkey';
Statement failed, SQLCODE = -904

unavailable database

*) file exists
C:\WORK\FIREBIRD1\bin>dir "C:\WORK\FIREBIRD1\examples\EMPLOYEE.FDB"
Volume in drive C has no label.
Volume Serial Number is 14C0-8D8D

Directory of C:\WORK\FIREBIRD1\examples

23.02.2004 01:05 1.028.096 EMPLOYEE.FDB
1 File(s) 1.028.096 bytes
0 Dir(s) 41.485.553.664 bytes free

*) local connect relativ

*) connect to sample database

C:\WORK\FIREBIRD1\bin>ISQL -u sysdba -password masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> CONNECT "localhost:C:\WORK\FIREBIRD1\examples\EMPLOYEE.FDB";
Statement failed, SQLCODE = -902

Unable to complete network request to host "localhost".
-Failed to establish a connection.
-The system could not find the environment option that was entered.

*) same with the logical name
SQL> CONNECT "SERVER1:C:\WORK\FIREBIRD1\examples\EMPLOYEE.FDB";
Statement failed, SQLCODE = -902

Unable to complete network request to host "SERVER1".
-Failed to establish a connection.
-The system could not find the environment option that was entered.

*) and again with slashes as listed above...
C:\WORK\FIREBIRD1\bin>ISQL -u sysdba -password masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> CONNECT "SERVER1:C:/WORK/FIREBIRD1/examples/EMPLOYEE.FDB";
Statement failed, SQLCODE = -902

Unable to complete network request to host "SERVER1".
-Failed to establish a connection.
-The system could not find the environment option that was entered.

Thanx for any help
bg