<cfset rs = cfusion_disable_dbconnections("myDSN","1")>
The following line enables the data source named cfmysource:
<cfset rs = cfusion_disable_dbconnections("myDSN","0")>

You can also uncheck Maintain Database Connections in the CF admin and the
database will never lock.

jon
----- Original Message -----
From: "Kris Pilles" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 10:31 AM
Subject: Releasing Access locks with Coldfusion?


> Anyone know how to release all locks on an access database via coldfusion?
>
> I am having some trouble with getting one of our datasources to release
its
> current locking thus preventing me from uploading a new copy of the DB.
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to