Ryan,

I do not have any issue on XP SP2 with local connections or embedded
connections or connections to the security database, and I have never
experienced such an issue with any customers XP machines.

Your particular issue with XP may be because Firebird does not allow
multiple connections on a local connection, which is quite different
to the problem I am describing. With windows 2003, I have a problem
even if I am the only user.

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.

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
> >
> >
> >
> >
> >
> >
> >
>