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