Hi Rob,

The tcp connections to the database work fine, it's just the local
connections that give the 'unavailable database' error.

Cheers,

Ryan Thomas
TransActive Systems

P: (02) 4322 3302
F: (02) 4325 1141
E: ryan@...
W: http://www.transactive.com.au/

> Hi
>
> I just realized I think know the answer to this problem. Amazing !!!
>
> The issue is probably related to small business server. A
> techie told
> me that One of the 'services' provided by SBS uses the same port as
> Firebird. Try changing the firebird port to something different and
> see if the problem goes away.
>
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
> Ryan Thomas wrote:
>
> >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
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >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
>
>
>
>
>
>
>