This works with Access (so I'm not sure if it'll work in your case), and
it's a quick-and-dirty approach, so YMMV. Todd's idea is better in the long
run, but if you absolutely must kill the lock on the DB *right now*, try
this:
Just make a bogus SELECT query (usually I pull from a table named 50
characters of gibberish). In Access it kills the lock on the DB, and it
might help out in Sybase.
HTH,
Jamie
--
Jamie Keane
Programmer
SolutionMasters, Inc.
9111 Monroe Rd., Suite 100
Charlotte, NC 28270
www.solutionmasters.com
704.563.5559 x 228 Voice
704.849.9291 Fax
-----Original Message-----
From: Todd Ashworth <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Friday, September 01, 2000 10:03 AM
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.
