Hi Rob,

I'm not 100% on this, but doesn't the local connection protocol bypass the
tcp stack, so it shouldn't really matter if there's something else there or
not.

I'll have a look anyway.

Cheers,

Ryan Thomas
TransActive Systems

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

> 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
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Fair play? Video games influencing politics. Click and talk back!
> http://us.click.yahoo.com/T8sf5C/tzNLAA/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
>
>
>
>
>
>
>