Windows through another tantrum and sent before I had added notes ;)

Helen Borrie wrote:

> At 01:57 AM 23/07/2006, you wrote:
>
>>Hello all,
>>
>>I thought I would post this to the forums for anyone using Firebird on
>>Windows with Codecharge or other IDEs.
>>
>>The link to the support case is here:
>>http://support.yessoftware.com/usrCaseResponses.asp?case_id=983922141&em\
>>ail=david@...
>><http://support.yessoftware.com/usrCaseResponses.asp?case_id=983922141&e\
>>mail=david@...>

> The link doesn't seem to be accessible by non-members.

You are not devious enough Helen ;)

----
I jumped the gun because when I had a similar error (refer to Case #
983909527 from CCS in Nov 2004) and the same symptoms, that were
resolved by your assistance by adding some code to the interbase.php
common file, and changing the server connection parameters. So I figured
it was a Codecharge issue. The solution was to add gds_db 3050/tcp to
the Services file in the windows directory. I am surprised Firebird does
not do this automatically on install?
----

>>My question for the Firebird team, is related to the last comment in
>>this case, why would I manually have to add the gds_db 3050/tcp entry
>>to the SERVICES file in Windows.
>>
>>It is funny because IBExpert had not problem connecting without it, but
>>the IDE did.
>>
>>Is this something that Firebird should add on install? Or is this a
>>Codecharge issue? Any feedback would be appreciated.
>
> It looks like a Codecharge issue (it's not a Firebird error
> message). It does depend on version, though. While Fb 1.5 and later
> default the host gds_db port to 3050 (thus making the Services entry
> optional) the older ones (Fb 1.0.x and Interbase) require it. The
> relevant installers behave accordingly.
>
> (See the v.1.5.3 release notes for info about how you can configure
> it to a different port).
>
>>PS: this is using PHP/Apache/Firebird on Windows
>
> If you don't get any more answers on this list (or even if you do)
> you could post a message to the firebird-php list to check whether it
> might be an issue with the PHP driver version you have.
>
> It would also be interesting to check whether CC accepts a TCP
> connection string that includes the host port:
>
> myhost/3050:c:\databases\mydb.fdb

We *DO* need to look at the php_interbase and try and get it up to date.
It works fine which is why nobody is too worried. Even the niggles I
have been having have been PHP related rather then the database
connection ;)
Ard does seem to have disappeared, so I think I am going to have to bite
the bullet and start having a look myself. php_interbase needs the
legacy stuff set even to run, so the legacy 'gds_db 3050/tcp' is
probably not surprising and needs updating at the PHP end - I think.

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services - http://home.lsces.co.uk
Model Engineers Digital Workshop -
http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Treasurer - Firebird Foundation Inc. - http://www.firebirdsql.org/index.php