--- In firebird-support@yahoogroups.com, "hay77772000" <dhay@l...>
wrote:

> --- In firebird-support@yahoogroups.com, "lance8086"

<lance8086@y...>

> wrote:
> > --- In firebird-support@yahoogroups.com, "hay77772000"

<dhay@l...>

> > wrote:
> >
> > > Any other ideas, anyone?
> > Let's see your connection string
> SQL> connect 'c:\Program Files\Firebird\Firebird_1_5

\data\OLYMPUS_PROT

> OTYPE.GDB' user 'SYSDBA' password 'masterkey';
>
> that fails with -904.
>
> SQL> connect 'localhost:c:\Program
> Files\Firebird\Firebird_1_5\data\OLYMPUS_PROTOTYPE.GDB'

user 'SYSDBA'

> password 'masterkey';
>
> That works.

So we know that the your fb server can access the files through the
loopback, but not through a local connection.

The file permissions are correct?
But that usually shows up as a -902 error.

AntiViral software interference perhaps?

Try changing the extension to FDB.
Helen mentioned GDB files. XP has some weirdness with those,
although I can create and connect to GDB files w/o problems.

Try connecting to Security.FDB.

I tried a few things and found a way to break my installation. I
changed firebird.conf, createinternalwindow=0. That effectively
disabled local connections, which are your symptoms.

The service is running as 'local system', correct? I can't do a
local connection when the service is configured to run as a specific
user. But that's a side effect of not being able to configure a
specific user to interact with the desktop.

If all else fails, don't worry about it.
(I know - it bugs you that it doesn't work).
Just put an entry in aliases.conf
olympus=(path to database)
and connect with 'localhost:olympus'
Consolation prize - its less typing.