I think releasing the DSN programmatically also removes the Access lock:
<CFSET temp=CFUSION_DISABLE_DBCONNECTIONS("{your DSN here}", 1)>
Of course, don't forget to re-enable the DSN:
<CFSET temp=CFUSION_DISABLE_DBCONNECTIONS("{your DSN here}", 0)>
If you're unfamiliar with the CFUSION_DISABLE_DBCONNECTIONS() function,
it's undocumented. Or at least was in the past.
--Dylan
-----Original Message-----
From: David D. Droddy [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 2:04 PM
To: CF-Server
Subject: Re: Access .ldb files
I'm not too sure about MX control over this, but I know a trick for
releasing .ldb files.
You have to create a page with a query to the DSN for the locked file.
The query should request from a table that does NOT exist in the
database so
it will give a SQL error when accessed.
Open the error generating page in your browser.
The .ldb should disappear, but only until another user/app. accesses the
DSN
with a valid query.
Glad I can finally contribute to this forum!!
David Droddy
----- Original Message -----
From: "Priscilla Yamin" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 4:03 PM
Subject: Access .ldb files
> With Cold Fusion Server 5, I deselected the "maintain connections"
and
clients were able to access their ODBC databases with ftp. Since I have
upgraded to Cold Fusion MX, the client is complaining that the files are
locked and asking that I release them. Is their something different
about MX
in the way it handles this that I can control?
>
> Thanks
>
>
>
>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
