Hi,
You can break the lock by running a query on the datasource that causes
an error
select *
from x
(in this case x stands for a table that does not exist).
This should break the lock and allow the uploading of the db.
Chuck Rodgers
At 03:36 PM 12/10/01 -0500, you wrote:
Customer has
Have two datasources databases. Have person upload datasource 2 while
the site uses datasource 1. Do a query of datasource 2, loop through it
and update datasource 1. Maybe have a scheduled task do this at a time
that would be least disruptive. There are probably better ways to do
this,
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 3:33 PM
To: CF-Talk
Subject: Re: Disconnecting Data Sources for Upload?
Have two datasources databases. Have person upload datasource 2 while
the site uses datasource 1. Do a query of datasource 2, loop through it
and update datasource 1
This is a bit of a bubblegum solution, but you can have your client run a
lock killing query just prior to upload. Just setup a quesry that they can
navigate to in their browser (I call it qLockKiller.cfm). The SQL should be
something like SELECT something FROM nothing. That will cause a db
.
--- Ben
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 4:13 PM
To: CF-Talk
Subject: Re: Disconnecting Data Sources for Upload?
This is a bit of a bubblegum solution, but you can have your client run a
lock killing query just prior
If I remember correctly the bad query solution was a bug, and stopped
working in 4.5. I do remember it not working in 4.5 for me... In versions
4.5+ there is a specific function for this.
From the 4.5 Release notes
cfset rs = cfusion_disable_dbconnections(myDSN,1)
The following line enables the
to, or will I have to launch a fake query?
Mike :^)
-Original Message-
From: Ben Forta [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 4:16 PM
To: CF-Talk
Subject: RE: Disconnecting Data Sources for Upload?
Actually, the real solution is to not use shared file base
.
--- Ben
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 10, 2001 4:13 PM
To: CF-Talk
Subject: Re: Disconnecting Data Sources for Upload?
This is a bit of a bubblegum solution, but you can have your client run a
lock killing query just prior
: Monday, December 10, 2001 4:38 PM
To: CF-Talk
Subject: Re: Disconnecting Data Sources for Upload?
If I remember correctly the bad query solution was a bug, and stopped
working in 4.5. I do remember it not working in 4.5 for me... In versions
4.5+ there is a specific function for this.
From the 4.5
]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: Disconnecting Data Sources for Upload?
Date: Mon, 10 Dec 2001 15:57:44 -0500
Ben,
That sounds like a good solution.
Thanks.
John McKown, President
Delaware.Net, Inc.
28 Old Rudnick Lane
Dover, DE 19901
e-mail: [EMAIL
10 matches
Mail list logo
