I would like to say that you have this information wrong, from memory if the
second option is clicked then it maintains the connection. so unchecking it
would close it when not being used. And the other one is for disabling the
DB connection:-)
I think you need to rethink what you said:-)
-----Original Message-----
From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 2 September 2000 12: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.
