Subject Re: [firebird-support] Web application failure
Author Jules
I have since rebooted our webserver and have found the application errors have been fewer but intial error still remains.

* Our application is running on an 2000 IIS6 server seperate from our fb1.5 install running on FedoraCore4.

* The web application is written in Delphi 7 and uses the Interbase Access components to
connect to Firebird.

* The Web application holds a session open for the web user while they are active and times
out the session after an hour of inactivity (when the wander away). The objects for the
session will be being destroyed when the timeout happens - there is no explicit closing of
database connections and am assuming the objects do that themselves.

----- Original Message -----
From: Helen Borrie
To: firebird-support@yahoogroups.com
Sent: Tuesday, May 02, 2006 5:35 PM
Subject: Re: [firebird-support] Web application failure


At 04:55 PM 2/05/2006, you wrote:
>We have transferred from fb1.02 to fb1.05 and are very happy with
>the performance.
>
>Since transferring to 1.5 we have found that an existing application
>often fails to serve giving an error on our webserver (not the client):
>
>" An existing connection was forcibly closed by the remote host"
>
>I have used the instclient.exe to include the fbclient.dll with the
>gds32.dll in the \system32 directory thinking that this would solve our issue.
>
>Below is the firebird.log
>
>neo (Server) Tue May 2 15:41:41 2006
> INET/inet_error: read errno = 104
>
>neo (Server) Tue May 2 15:45:06 2006
> INET/inet_error: read errno = 104
>
>neo (Server) Tue May 2 15:53:07 2006
> INET/inet_error: read errno = 104
>
>neo (Server) Tue May 2 16:44:13 2006
> INET/inet_error: read errno = 104
>
>Any ideas?

These errors are just saying that the server has lost contact with a
client that it is has been listening to - quite typical when the
client is a browser.

Tell us more about the architecture - is "the webserver" an
application on the same machine where Firebird and the database
are? Or are you referring to a separate machine? How does the web
application connect to the database? Does the webserver keep account
of clients and take action to end their database work when they
wander away? What's the OS platform? etc., etc.

./heLen



++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




SPONSORED LINKS Technical support Computer technical support Compaq computer technical support
Compaq technical support Hewlett packard technical support Microsoft technical support


------------------------------------------------------------------------------
YAHOO! GROUPS LINKS

a.. Visit your group "firebird-support" on the web.

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


------------------------------------------------------------------------------



[Non-text portions of this message have been removed]