Ask a Question related to Coldfusion Database Access, Design and Development.
-
mohm #1
Downloading an Access file
I need to ftp download a copy of an MS Access .mdb file on a daily basis from a
MS IIS server using CF 5. The .ldb file is locking up not allowing the download
of the .mdb when the app is in use. I can copy the file to another directory
then download that copy but this is not an acceptable solution for the users. I
understand that CF 5 locks up the ldb file and can hold it up to 3 minutes
longer than it is in use. Has anyone found a work around for downloading an
mdb file that is locked without copying or stopping the server? Thanks
mohm Guest
-
Downloading file
i want to click on a link which then displays a file on the cd in word, how can i make this file able to be downloaded on the users computer? i... -
File Downloading from Flash
I am trying to implement a File Download in Flash but I don't know how. I know that can be done since in the Macromedia Exchange there is a... -
Downloading file(s) from CD
How can I make a button which start a downloading of file or more from the CD the presentation is running from, into the local hard disk in a... -
Downloading a file from a CD
Hi, Im using Director MX. On my CD, I want people to be able to click on an option that starts to download a video from my CD to the users... -
Downloading a file
I want my users to access my .aspx and hit a button to download a file. I tried using the a System.Net.Webclient object but instead of the file... -
Vbprog40 #2 Re: Downloading an Access file
Create a CFM file named "Unlock.cfm" (Or whatever you want)
Add this code to it:
<cfset tempkill = CFUSION_DBCONNECTIONS_FLUSH()>
<cfquery name="test" datasource=" DS NAME HERE ">
SELECT bogus
FROM bogustable
</cfquery>
This will query a bogus table and flush teh connections at the same time. It
will unlock your database file.
Vbprog40 Guest
-
Fodor #3 Re: Downloading an Access file
I made the following cfm file, and placed it within my root folder and it did
not unlock the mydatabase.ldb file. I use an ISP's ColdFusion 7 with no access
to the CFAdmin. See: [url]http://www.billcory.net/GuestBook.swf[/url]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<cfset tempkill = CFUSION_DBCONNECTIONS_FLUSH()>
<cfquery name="test" datasource="backyardY7_accesscf_GuestBook">
SELECT bogus
FROM bogustable
</cfquery>
</body>
Fodor Guest
-
philh #4 Re: Downloading an Access file
The bogus query solution doesn't work anymore. You have to uncheck "Maintain
Database Connections" for your DSN. The performance tradeoff is the issue, but
at least you'll have a chance to grab the file. I'd suggest an admin template
that disables your application while you attempt to download the MDB; that way
no one will re-establish the connection and the lock file.
philh Guest
-
jorgepino #5 Re: Downloading an Access file
what a about copy the Access File to a temp database file download and then delete temp file
not need to disconnect
jorgepino Guest
-
philh #6 Re: Downloading an Access file
Originally posted by: mohm
I can copy the file to another directory then download that copy but this is not an acceptable solution for the users.
That's why you can't use the copy approach.
philh Guest
-
VorDesigns #7 Re: Downloading an Access file
Uh, if this is a system you have control over, why can't you make a copy and
download it? Their isn't much of a difference.
Modify your application to not allow exclusive locks.
Pull the file during the daily flush of CF; you are clearing the boards
nightly aren't you?
VorDesigns Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
