Tony, If you go to the CF Administrator and go to the Verify Datasources page you will find a "release" button at the top of the page. Hitting the button will drop _ALL_ connections to _all_ databases. This won't affect any other applications, other than to cause a short period where pages are slower while db connections are re-made and cached.
If you are intending to over-write your database on a regular basis, it is worth while changing the datasource settings so that connections to the database are _not_ maintained. This should save you from having to drop all connections to all databases in order to release the one database. Hope this helps. Regards Stephen > -----Original Message----- > From: Tony Hicks [mailto:[EMAIL PROTECTED]] > Sent: 02 October 2001 12:02 > To: CF-Talk > Subject: URGENT: Postpone data connection > > > I can't access my database.. I can't overwrite it.. something went > wrong.. > > Is there a way in CF,JSP or ASP to put it on pause so that I can upload > the database and 'hit play' again? > > Thanks, > Tony Hicks > ---------- > Search the Holy Bible: http://www.bibleclicks.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
