Yes, the database connection on my server remains open even after the
session has been closed. I'm looking at my DSN, but the Sybase 5.5.04
driver doesn't have that option. I've tried in my CF 4.0 Administrator to
set the Limit database connection inactive time to 1 minute, that doesn't
seem to work either.
Boris
-----Original Message-----
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: September 1, 2000 7:10 AM
To: [EMAIL PROTECTED]
Subject: Re: CF not letting go of database connection?
Do you mean that the database engine stays running even after the last
connection has been closed?
If so, go to your ODBC administrator in your control panel and open the
properties for the DSN in question. Under the "Database" tab, you will have
2 checkboxes at the bottom. One is to automaticly start the database if it
isn't running and the other is to shut down the database after the last
disconnect. You will want to check the second one. Note that with this
option checked, anytime the database is not being queried, the database
engine will shut down. This means that it will have to restart every time a
new query comes along, which adds about 1 second of overhead (YMMV).
Todd Ashworth
----- Original Message -----
From: "Boris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 31, 2000 1:20 PM
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/cf-talk@houseoffusion.com/
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/cf-talk@houseoffusion.com/
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.
