Opps snipped the first line, and the dsn was named wrong :) This is CF 4.5+
only
The following line disables the data source.
<cfset rs = cfusion_disable_dbconnections("myDSN","1")>
The following line enables the data source.
<cfset rs = cfusion_disable_dbconnections("myDSN","0")>
jon
----- Original Message -----
From: "Jon Hall" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, December 12, 2001 10:46 AM
Subject: Re: Releasing Access locks with Coldfusion?
> <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.
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
