*snip*

> > Next thing I wanted to do was change the sysdba password using gsec.
> In
> > the Command Prompt I did:
> >
> > C:\Program Files\Firebird\Firebird_1_5>bin\gsec -user
> sysdba -password
> > masterkey
> >
> > and got:
> >
> > unavailable database
> > unable to open database
>
> This is the exact error message I received a week or two ago. I
> believe there is a bug in Firebird 1.5 running on Windows 2003 Server
> which prevents local connections from being made.

We also receive this message on all of our computers here (XP, FB SS 1.5.2).
Local connections were fine when running FB 1.0 - after we updated
everything we could no longer establish local connections. To work around it
we just place a ':' in front of the database location (this is the same as
specifying the localhostfor tcp connections, is it not?).

> I am unable to use the embedded version of our application on Windows
> 2003, unavailable database.

This is strange, whilst we cannot establish local connections with SS, we
can get connections using FB embedded...

*snip*

We get the same results with iSQL.

>
> If someone can confirm this behaviour on their system, then I will log
> it in the incident tracker, I do not believe it is specific to our
> implementation because I have seen it on a customers server as well.
>
> > So my question is, what have I missed that I am unable to run gsec?
> >
>
> My guess, gsec is trying to access the security database via a local
> connection. On a side note, I hope this issue is resolved before FB 2,
> because from memory you can not connect to the security database
> directly then.

We also had the trouble accessing the security database (adding users)
through IB_SQL when connected with localhost:database or 127.0.0.1:database
- we got the unavailable database error. To work around this we changed the
ip to the actual ip of the machine I was on (in this case 10.1.1.45) and we
could add users.

I would love to know if there is a solution to this.

Cheers,

-Ryan

> Adam
>
>
>
>
>
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Get Bzzzy! (real tools to help you find a job). Welcome to
> the Sweet Life.
> http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/67folB/TM
> --------------------------------------------------------------
> ------~->
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>