On Tuesday, September 17, 2002, at 12:07 PM, Greg Luce wrote:
> Can someone clear this up for me. I maintain a site on a shared server
> and it uses access :-(. Seems every time I need to alter the mdb file
> it's locked on the server. I've asked the hosting company to uncheck
> "Maintain Database Connection" for the datasource and they came up with
> some BS answer that it keeps multiple connections being made. Isn't it
> just for efficiency so CF doesn't have to connect every time a call is
> made? Through the host's user interface you can restart the webserver,
> but not CF. I've tried putting up a bogus page with an invalid SQL
> query. Isn't that supposed to release it?
That used to work, I believe prior to CF 5. For CF 5 servers I use the
following:
<cfset rc=cfusion_disable_dbconnections("yourdsn",1)>
and then re-enable with:
<cfset rc=cfusion_disable_dbconnections("yourdsn",0)>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
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
