but i would only do that on development and test servers...
on production servers i would maintain those connections...
my recommendation...
Terry Bader
IT/Web Specialist
EDO Corp - Combat Systems
(757) 424-1004 ext 361 - Work
[EMAIL PROTECTED]
(757)581-5981 - Mobile
[EMAIL PROTECTED]
icq: 5202487 aim: lv2bounce
http://www.cs.odu.edu/~bader
-----Original Message-----
From: Chris Alvarado [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 11:29 AM
To: CF-Talk
Subject: RE: Unlocking Access database under CF 4.5
One thing to remember. When creating an ODBC connection to an Access DB
through the CF Administrator, UNcheck the 'Maintain Database Connections'
checkbox (you may have to click the 'CF Settings' button to expand the
page). I have had problems with this locking the connection to the DB in the
past, especially if the user stops the processing of the pade in
mid-request.
-chris.alvarado
[developer] - VerticalNet
-----Original Message-----
From: Aidan Whitehall [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 12, 2001 10:25 AM
To: CF-Talk
Subject: RE: Unlocking Access database under CF 4.5
> I have checked the CF archives looking for unlocking an
> access database. I
> found that issuing an invalid query against the datasource
> will release the
> lock. I have tried this under my current ISP, but no go. Is
> there anything
> different under CF4.5?
There have been a few times when running the bogus query didn't work, but I
just left it an hour or so, ran it again and the lockfile was deleted.
Don't think the fact that they're running 4.5 will make any difference (but
correct me people if that's wrong).
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
