Re: [CFTALKTor] Database Locks

[Bob Creedy]

Yes, you can break the lock by issuing a dummy sql statement that fails against the database.  For example I issue the following sql statement a few seconds before ftp'ing the database: select * from asdf asdf desn't exist so the statement fails.  This breaks the lock. Sounds nuts but I've had this working on a daily basis for over 2 years and it works well. Bob Mike wrote: Hello All, I have a question regarding a daily process that is starting to cause us some issues with the way our ISP handles our database connection. We have a program that creates an access database overnight. This database is then sent FTP to our ISP where it over writes the database for a website that allows one of our clients to view data which is contained in the data base.  This is fine if nobody has accessed the website in the last little while the database is over written no problem.  The issue I have is when a person views a webpage a 9:00 am and I want to over write the database at 9:15 there is a lock on the database. I guess I am looking for a way to import and modify data in the database without actually overwriting the database. Does anyone know how to do this in Coldfusion? thanks Mike -- -------------------------------------------------------------------------------- Robert Creedy Computing & Communications Services University of Guelph Ontario, Canada (519) 824-4120 x2589 --------------------------------------------------------------------------------