Have similar situation. What I did was upload that database, then copy all
its contents to the production database. That way it doesn't matter how
many people are connected, the info gets updated, and you have a backup
should something happen to the production DB either during transfere or
anything else. Just recopy and off you go. Hope this helps...
cw
-----Original Message-----
From: Douglas Knudsen [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 07, 2001 12:20 PM
To: CF-Talk
Subject: Re: Those darn Access .ldb files
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
