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
