Hi Adam,

> If anyone is running Windows 2003, try and connect to a database
> using isql and a local string, and tell me I am not going nuts.
>

I gave it a try on a win2k3 small business server we have access to and came
to the same conclusion that you did. I get the unavailable database error
when trying to connect to the database with no other users on the system.

So, no - I guess you aren't going nuts ;)

Cheers,

Ryan

> Adam
>
>
> --- In firebird-support@yahoogroups.com, "Ryan Thomas" <ryan@t...>
> wrote:
> >
> > *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
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> >
>
>
>
>
>
>
> ------------------------ 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
>
>
>
>
>
>
>