RE: Extremely Persistant Access ldb Lock File
In the CF admin, make sure Maintain Database Connection is not checked. That should help. www.easycfm.com also has some very nice, quick tutorials on how to create CFM pages that can add/delete data from the db without having to FTP it. Dan Phillips www.CFXHosting.com 1-866-239-4678 [EMAIL PROTECTED] Do you want complete ColdFusion Administrator access? RDS? Terminal Server?- CFX-Advanced VPS - http://www.cfxhosting.com/Plans/s_cfxadvancedVPS.cfm -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 11:35 AM To: CF-Talk Subject: Extremely Persistant Access ldb Lock File This one has got a client almost in tears. There's a large Access file which a client needs to update twice a day by ftp'ing a new version in (Hey, I tried to convince them to use SQL...). Problem is, there's a persistent ldb on the database that almost NOTHING can seem to make go away. So, when time comes to ftp a new database, they can't - the file is locked - for hours and hours at a time, even if nobody is accessing the site and using the database. Evening putting one of my breakconnection.cfm files out there that purposely errors to break the connection won't kill it. They've got the timeout set in the CF Admin to 1 minute. Ideas? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
RE: Extremely Persistant Access ldb Lock File
Les, This is undocumented so I take no responsibility for it - it does work however. CFUSION_DBCONNECTIONS_FLUSH(); -Mark -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 10:35 AM To: CF-Talk Subject: Extremely Persistant Access ldb Lock File This one has got a client almost in tears. There's a large Access file which a client needs to update twice a day by ftp'ing a new version in (Hey, I tried to convince them to use SQL...). Problem is, there's a persistent ldb on the database that almost NOTHING can seem to make go away. So, when time comes to ftp a new database, they can't - the file is locked - for hours and hours at a time, even if nobody is accessing the site and using the database. Evening putting one of my breakconnection.cfm files out there that purposely errors to break the connection won't kill it. They've got the timeout set in the CF Admin to 1 minute. Ideas? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com
RE: Extremely Persistant Access ldb Lock File
Assuming this is a win32 environment? kill.exe or pskill.exe are you're friends - if you don't have kill.exe from I think the nt4.0 optionkit, the psutils from www.sysinternals.com should be your bestest friends ever - and they're free! stop IIS/Apache and stop CF then kill the processes with the exes, delete the LDB file, rename the original.mdb file and restart the services. upload your access database. Batchfiles are you're friend. that'll get through 95% of issues causing ldb locks. the other 5% generally require a restart of the server. Moral of the story is use SQL :) -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Thursday, 4 September 2003 1:35 AM To: CF-Talk Subject: Extremely Persistant Access ldb Lock File This one has got a client almost in tears. There's a large Access file which a client needs to update twice a day by ftp'ing a new version in (Hey, I tried to convince them to use SQL...). Problem is, there's a persistent ldb on the database that almost NOTHING can seem to make go away. So, when time comes to ftp a new database, they can't - the file is locked - for hours and hours at a time, even if nobody is accessing the site and using the database. Evening putting one of my breakconnection.cfm files out there that purposely errors to break the connection won't kill it. They've got the timeout set in the CF Admin to 1 minute. Ideas? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
RE: Extremely Persistant Access ldb Lock File
Check the CFAdministrator Datasource definition and make sure Maintain Database Connection is NOT checked. J -Original Message- From: Les Mizzell [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 03, 2003 8:35 AM To: CF-Talk Subject: Extremely Persistant Access ldb Lock File This one has got a client almost in tears. There's a large Access file which a client needs to update twice a day by ftp'ing a new version in (Hey, I tried to convince them to use SQL...). Problem is, there's a persistent ldb on the database that almost NOTHING can seem to make go away. So, when time comes to ftp a new database, they can't - the file is locked - for hours and hours at a time, even if nobody is accessing the site and using the database. Evening putting one of my breakconnection.cfm files out there that purposely errors to break the connection won't kill it. They've got the timeout set in the CF Admin to 1 minute. Ideas? ~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm