This came up in another cold fusion mail list today.
Here is and was my answer....
What may work for you is to force an error on the database.
That is find a query that will return an error and that should unlock it.
If that does not work, something in the future you can do is create your
database name dynamically and create that variable within the application
cfm file. When you are ready to take your database down, make a copy of
the database with a new name and use that new name as a temp database. If
users continue to hit your site, and are able to hit the database at all,
it will continue to stay locked. This will prevent the database you are
trying to unlock from remaining locked by users hitting the site.
kaigler
At 06:10 PM 1/16/2001 -0800, you wrote:
>Is it possible to kill a db connection if you don't have any admin
>privilidges on the CF server?
>
>It sucks to try update the db only to find out that you have to wait for a
>db connection to timeout...
>
>^^^^^^^^^^^^^^^^^^
>
>Tomas Becklin
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
