If I remember correctly the bad query solution was a bug, and stopped
working in 4.5. I do remember it not working in 4.5 for me... In versions
4.5+ there is a specific function for this.
>From the 4.5 Release notes
<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: "John McKown" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 10, 2001 3:36 PM
Subject: Disconnecting Data Sources for Upload?
> Customer has Access database that he uploads to CF Server via FTP.
> Access database is a datasource for his site.
> When site is being viewed, he cannot upload a newer copy of the database
> because the file is locked.
>
> Any creative solutions besides "disconnect the datasource"?
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
