Subject Keeping database connection permanently open
Author Nols Smit
Hi,

I've some applications, written in Delphi 7 using the IntraWeb (& TMSIntraWeb) components and running as an Apache dll under Windows 2000.

I notice after some time of no activity, the database shuts down. Is there a way to configure FireBird (and/or Apache) never to shut down, even if there are no active connections?

Or must I rather in the in the process (IntraWeb server controller) try to keep the database connection alive by occasionally access one record in a table?

In the firebird.conf file, I noteced the following comments:

# Normally, Firebird uses SO_KEEPALIVE socket option to keep track of
# active connections. If you do not like default 2-hour keepalive timeout
# then adjust your server OS settings appropriately. On UNIX-like OS's,
# modify contents of /proc/sys/net/ipv4/tcp_keepalive_*. On Windows,
# follow instrutions of this article:
# http://support.microsoft.com/default.aspx?kbid=140325

Is this something to look at?

(I use the installation defaults of Apache and FireBird 1.5)


Regards,

Nols Smit



Disclaimer Legal Notice:
By having opened and read this electronic mail, you are deemed to have
understood and accepted all disclaimers and conditions pertaining to
electronic mail emanating from, and received by The Council for Geoscience,
further detail of which may be viewed at the following hyperlink:
http://www.geoscience.org.za/disclaimer.htm




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