Breaking Datasource Connection
I know, I know - this has been asked a trillion times. I need to upload a brand new copy of the access database, but 'its in use by another processs' so of course the upload fails. How do I break the connection so I can upload the updated database? Thanks. Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Breaking Datasource Connection
Query a table that doesn't exist. It will unlock the database: CFQUERY DATASOURCE="#DSN#" SELECT * FROM FourScoreAndSevenYearsAgo /CFQUERY That'll do it. --Ben At 10:09 AM 4/6/01, you wrote: I know, I know - this has been asked a trillion times. I need to upload a brand new copy of the access database, but 'its in use by another processs' so of course the upload fails. How do I break the connection so I can upload the updated database? Thanks. Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Breaking Datasource Connection
Write a query to that Datasource that is bad - I.E. a non existant table. Then as soon as you run that script, begin you upload before something else grabs the database. Dave - Original Message - From: "Erika Foster" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Friday, April 06, 2001 11:09 AM Subject: Breaking Datasource Connection I know, I know - this has been asked a trillion times. I need to upload a brand new copy of the access database, but 'its in use by another processs' so of course the upload fails. How do I break the connection so I can upload the updated database? Thanks. Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Breaking Datasource Connection
I write a simple template to run when needed like so: cfquery name="killdb" datasource="DSN_NAme" SELECT * FROM CRAP /cfquery Since I have no table in my DSN called crap it returns an error which breaks the connection Save the file in a hard to find directory under your domain so that someone else doesn't run it on you. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 10:10 AM To: CF-Talk Subject: Breaking Datasource Connection I know, I know - this has been asked a trillion times. I need to upload a brand new copy of the access database, but 'its in use by another processs' so of course the upload fails. How do I break the connection so I can upload the updated database? Thanks. Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Breaking Datasource Connection
Two ways come to mind.. (http://cfhub.com/faq/access_lock.cfm) cfquery datasource="YourODBCDataSource" Select BadData FROM UnknownTable /cfquery !---Seriously OverKill last resort... you get the picture--- cfset CFUSION_DBCONNECTIONS_FLUSH() ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Breaking Datasource Connection
Before doing this, you will need to make sure no one else would be attempting to write data to the database. Just do a simply Query that causes an error with the database. CFQUERY NAME="KILLLDB" DATASOURCE="#application.DSN#" Select * From NOTABLE /CFQUERY Make sure that this Datasource is correct and the table name you specify in the query does NOT exist. This will kill the LDB locking file. -Original Message- From: Erika Foster [mailto:[EMAIL PROTECTED]] Sent: Friday, April 06, 2001 11:10 AM To: CF-Talk Subject: Breaking Datasource Connection I know, I know - this has been asked a trillion times. I need to upload a brand new copy of the access database, but 'its in use by another processs' so of course the upload fails. How do I break the connection so I can upload the updated database? Thanks. Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists