We are using IBX components to connect to firebird.

Also we have found that odbc connections have been dropping to the db also. Ibexpert app has some connection issues too.

Is there a time out set by the db that disconnects sessions?

Julie

----- Original Message -----
From: Daniel Rail
To: firebird-support@yahoogroups.com
Sent: Wednesday, May 03, 2006 6:59 PM
Subject: Re: [firebird-support] Web application failure


Hi,

At May 3, 2006, 2:50 AM, Jules wrote:

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

Here I'm assuming that the connection is made via TCP/IP. Am I right?
What is the isolation level for the web app on IIS(set at the folder
level)?

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

Which component set for the web app are you using?

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

This will depend on the web app isolation level that is chosen in IIS.

--
Best regards,
Daniel Rail
Senior Software Developer
ACCRA Consultants Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)



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

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]