I write a simple template to run when needed like so:
<cfquery name="killdb" datasource="DSN_NAme">
SELECT *
FROM CRAP
</cfquery>
Since I have no table in my DSN called crap it returns an error which breaks
the connection
Save the file in a hard to find directory under your domain so that someone
else doesn't run it on you.
Larry Juncker
Senior Cold Fusion Developer
Heartland Communications Group, Inc.
-----Original Message-----
From: Erika Foster [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 06, 2001 10:10 AM
To: CF-Talk
Subject: Breaking Datasource Connection
I know, I know - this has been asked a trillion times.
I need to upload a brand new copy of the access database, but 'its in use by
another processs' so of course the upload fails.
How do I break the connection so I can upload the updated database?
Thanks.
Erika Foster
engineering-environmental Management
Applications Developer
(505) 866-1654
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists