sorry i forgot to add,
that code i sent you is from a page that i use called unlock.cfm and i just
run that page when the db gets locked.
Jay Patton
Web Design / Application Design
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, March 07, 2001 9:15 AM
Subject: Those darn Access .ldb files
>
>
>
> 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
