RE: Release Database
Just put this in a template and view it in your browser, it will unlock your dbase connections. __ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -Original Message- From: Graham Lewis [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 12:56 PM To: CF-Talk Subject: Release Database I find that I cannot overwrite a database file since it appears that CF has it locked. How can I release it so I can overwrite it? Graham Graham Lewis Centre for Academic Practice University of Warwick CV4 7AL Tel: 024 765 73109 Mobile: 07733450022 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 __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
Re: Release Database
If you're using an Access database, and that's the lock you're trying to release, just run a query that will definitely fail, and that will release the lock on the file. Example: SELECT badColumn FROM badTable Since that table (hopefully!) doesn't exist, the lock will be released on the database file and you will be able to overwrite it. Hope this helps, Dave. Original Message Follows From: "Douglas Brown" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: Release Database Date: Thu, 7 Feb 2002 10:18:22 -0800 What are you using for you DB? You can simply right click on the DB in SQL and choose take offline. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: "Graham Lewis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 9:56 AM Subject: Release Database > I find that I cannot overwrite a database file since it appears that CF > has it locked. How can I release it so I can overwrite it? > > Graham > > Graham Lewis > Centre for Academic Practice > University of Warwick > CV4 7AL > Tel: 024 765 73109 > Mobile: 07733450022 > 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 > __ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
Re: Release Database
sounds like you are using Access? is there a .ldb file? If so then all you have to do is run a bad query against the database (mabye a few times). Create a file with the bad query (SELECT Something FROM Nothing) and run it in a browser.that will kill the lock file when it creates an error (if it doesn't work the first time...try again). You could also simply try restarting CF Server if you have access to it. HTH Bryan Stevenson VP & Director of E-Commerce Development Electric Edge Systems Group Inc. p. 250.920.8830 e. [EMAIL PROTECTED] - Macromedia Associate Partner www.macromedia.com - Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com - Original Message - From: "Graham Lewis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 9:56 AM Subject: Release Database > I find that I cannot overwrite a database file since it appears that CF > has it locked. How can I release it so I can overwrite it? > > Graham > > Graham Lewis > Centre for Academic Practice > University of Warwick > CV4 7AL > Tel: 024 765 73109 > Mobile: 07733450022 > 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 __ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
RE: Release Database
You need to do one of two things: 1) go the cfadmin and to the ODBC connection to your database (Access I am guessing) then turn off the "keep connections alive" until you are ready to go live with the whole thing. 2) copy the db, paste the copy and append a "_a" or whatever to the end - then go to the cfadmin (as above) and append the "_a" to the end of the path, wait for a while then work on the "old" version, then when you are ready swap them back... HTH J -Original Message- From: Graham Lewis [mailto:[EMAIL PROTECTED]] Sent: 07 February 2002 17:56 To: CF-Talk Subject: Release Database I find that I cannot overwrite a database file since it appears that CF has it locked. How can I release it so I can overwrite it? Graham Graham Lewis Centre for Academic Practice University of Warwick CV4 7AL Tel: 024 765 73109 Mobile: 07733450022 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
Re: Release Database
What are you using for you DB? You can simply right click on the DB in SQL and choose take offline. There are two major products that come out of Berkeley: LSD and [Unix] BSD. We don't believe this to be a coincidence. Doug Brown - Original Message - From: "Graham Lewis" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, February 07, 2002 9:56 AM Subject: Release Database > I find that I cannot overwrite a database file since it appears that CF > has it locked. How can I release it so I can overwrite it? > > Graham > > Graham Lewis > Centre for Academic Practice > University of Warwick > CV4 7AL > Tel: 024 765 73109 > Mobile: 07733450022 > 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 > __ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb 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
Release Database
I find that I cannot overwrite a database file since it appears that CF has it locked. How can I release it so I can overwrite it? Graham Graham Lewis Centre for Academic Practice University of Warwick CV4 7AL Tel: 024 765 73109 Mobile: 07733450022 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
