Hi Ryan

I would give it a go anyway. The local connection might be defaulting
to the SBS service whereas remote TCP/IP requests might be getting the
FB service.

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