ooops! The intent: I have a page that an end user can use to upload a
M$ db that resides on the web server. This db is manually updated
everyday. We would automate this by building a form and such, but the
end user(read customer) does not want to pay for it or change their
modus operandi(sp?) There is a web app that does an ODBC read to
this db that others use daily. Each time this occurs the .ldb file is
generated, if it doesn't already exist. So, I want my page to be able
to upload the updated mdb file to the web server and over write the
current one. So, I need this page to 'unlock' the current mdb file
and upload the newly updated mdb overwriting the current one all
without errors.
I know 3 below works, but what impact would this have on all the other
db based CF apps?
Thanks!
-----
Douglas Knudsen
Leveraged Technologies Group
678-351-6063
Got Linux? http://linuxmall.com
From: [EMAIL PROTECTED] AT INTERNET on 03/07/2001 02:43 PM
To: [EMAIL PROTECTED] AT INTERNET@CCMAIL
cc: (bcc: Douglas Knudsen/ATL/ALLTELCORP)
Subject: Re: Those darn Access .ldb files
I'm confused. Are you trying to unlock the database inside a
'functional' page that users will see?
I've only had to do this when I am copying over the database.
Using
method two, I would run it without the try/catch tags. If the page
throws
an error, who cares. It's a page for my own personal use. I'm just
running it to unlock the database.
Why do you need to unlock the database?
At 11:15 AM 03/07/2001 -0500, you wrote:
>Ok,
>
>I've searched through the House of Fusion Mail Archive and Allaire's
>support forums for info regarding how to unlock a M$ Access file
through
>CF. We are using NT4 SP5(or 6) and CF 4.0.1. I have done/tried the
>following:
>
>1) unchecked the 'maintan connections' checkbox in the ODBC setup for
the
>datasource in the CF Administrator.
>
> This did not work. When I do an ODBC read/write the lock
file is
>still generated
>
>2) tried performing a 'fake' query to the datasource
>
><CFTRY>
>
> <CFQUERY DATASOURCE="helpdesk_assets" NAME="Unlock">
> SELECT Rasputin
> FROM Russia
> WHERE Name = Gregori
> </CFQUERY>
>
> <CFCATCH>
> <p>worked?</p>
> </CFCATCH>
>
></CFTRY>
>
>
>This did not do it either. If I remove the TRY/CATCH code, the
dtabase is
>unlocked, but then I get a non-functional page. Is this code
correct?
>
>3) used this <CFSET CFUSION_DBCONNECTIONS_FLUSH()> in my page. This
>works, but I suspect it is not a good idea to use in a production
>environment as it kills ALL dbconnections. Any thoughts? (This is
all
>for an Intranet, hence the use of M$ Access)
>
>4) used this <CFSET rc=cfusion_disable_dbconnections("DSN","1") but
this
>throws an error.
>
>Any thoughts?
>
>
>-----
>Douglas Knudsen
>Leveraged Technologies Group
>678-351-6063
>Got Linux? http://linuxmall.com
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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