Oops .. sorry. I was giving you instructions for Sybase ASA 6.0.3
For 5.5.04, open your DSN properties. Beside "Database Startup", there is a
button labeled "Options". Click on that. In the middle of the next page,
you should see a check box labeled "Autostop database". Put a check in that
box and see if that helps.
Todd Ashworth
----- Original Message -----
From: "Boris" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, September 01, 2000 10:15 AM
Subject: FW: CF not letting go of database connection?
| 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.
|
------------------------------------------------------------------------------
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.
