uncheck the MAINTAIN DATABASE CONNECTION checkbox in the
CFAdministrator and
the lock will be released after the Excel file is read.
+-----------------------------------------------+
Bryan Love
Macromedia Certified Professional
Internet Application Developer
Database Analyst
Telecommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may
have
peace'..."
- Thomas Paine, The American Crisis
-----Original Message-----
From: Douglas Lamb [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 09, 2002 4:44 PM
To: CF-Talk
Subject: DBTYPE=Dynamic
I've got a dynamic datasource, correctly accessing an EXCEL
spreadsheet.
However; the connection does not close, and thus locks the file.
How do I force the ODBC connection to release the EXCEL file ??
Thanks.
Douglas
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
