Nope .. I double checked. The second option is labeled "Automatically shut
down database after last disconnect." That would lead me to believe that it
will do just what it says when checked. If left unchecked, it will leave
the database running. The first option says "Automatically start the
database if it isn't running." So, to have the database start by itself and
stay running, check the first box and uncheck the second. To have the
database start by itself and shut down after the last disconnect, check the
first and check the second.
Now, this is for Sybase. Are you speaking in reference to SQL Server by any
chance?
Todd Ashworth
----- Original Message -----
From: "Andrew Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 11:12 AM
Subject: RE: CF not letting go of database connection?
| 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/[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.
