This is a setting in the ColdFusion administrator. By default, ColdFusion
keeps connections open to save on the overhead of having to establish (and
kill) a new connection with every query. In general, it is a good thing, but
you can turn it off if necessary.
I have seen some instances where Microsoft SQL Server 6.5 (and earlier) will
not kill connections that have executed poorly written queries (especially
those with misplaced semicolons). This invariably leads to the TempDB
filling up or to the maximum allowed users being reached.
I only bring this up because, you mentioned that you're using Sybase which
is not entirely unlike Microsoft SQL Server 6.5. From what I understand, the
two operated off the same basic code base until Microsoft SQL Server 7.
Benjamin S. Rogers
Web Developer, c4.net
voice: (508) 240-0051
fax: (508) 240-0057
-----Original Message-----
From: Boris [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 1:21 PM
To: [EMAIL PROTECTED]
Subject: CF not letting go of database connection?
I have a number CF based pages that once the query is completed with the
data presented it will not let go of the database connection to my Sybase
SQL Anywhere database. Even after the page has been exited.
Any suggestion would be appreciated.
Boris
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
