Have you looked in the database tools or whatever there is for that to see if there is a keep connections open setting in there? It sounds like a dumb setting for it to have under the circumstances, but it's worth a peek.
On 7/20/05, Chris Lyman <[EMAIL PROTECTED]> wrote: > (have a headache yet?) Okay, now with CF the connections to the > DB are never closed. This means that the updates can't happen because ADS > has locked the data dictionary. I've tried the usual settings and I can't > get CF to release the connections reliably without restarting the server. > Does anybody have any ideas on how to get CF to either close all connections > on a given datasource, or to get CF to close a connection after it's done > with it. The check box in the administrator isn't doing it for me. -- "You can't destroy EVERYthing. Where would you sit?" The Tick Now blogging.... http://www.blivit.org/blog/index.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:10:5504 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/10 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:10 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.10 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
